software

I have a spreadsheet that I have been using for a couple of years but now
when I select a chart I lose my menu bar (file, edit, view etc). Also, I am
no longer able to right mouse click. If I select elsewhere on the sheet my
menu and mouse operations returns. Any help would be greatly appreciated. I
have tried resetting my worksheet menu bar by selecting tools/customise
toolbars but this doesn't help.

When you activate a chart the Worksheet Menu Bar (WMB) normally disappears
and the Chart Menu Bar (CMB) takes its place. The CMB looks exactly the same
except that it has a Chart menu in place of the Data menu. There is an
illusion that the WMB remains and only the menu item changes.

I'm guessing that the CMB has been docked, say, at the bottom of the window,
and so when the WMB disappears and the CMB takes its place (at the bottom
instead), it looks as though the WMB just disappeared. Alternatively, perhaps
the CMB has been disabled. To my knowledge, you can only disable it
programmatically:
Application.CommandBars(quot;Chart Menu Barquot;).Enabled = False

As for not being able to right mouse click, can you be more specific. I
suspect this has to do with the new protection features available that I'm
not up to date with. I'm running xl2000.

Regards,
Greg

quot;Alisonquot; wrote:

gt; I have a spreadsheet that I have been using for a couple of years but now
gt; when I select a chart I lose my menu bar (file, edit, view etc). Also, I am
gt; no longer able to right mouse click. If I select elsewhere on the sheet my
gt; menu and mouse operations returns. Any help would be greatly appreciated. I
gt; have tried resetting my worksheet menu bar by selecting tools/customise
gt; toolbars but this doesn't help.

Thanks Greg.
The CMB was not on the bottom in fact it must have been disabled by someone
elses program at some stage. But you gave me anough information to go into
the VB immediate screen and re-enable it. However, as for the mouse it is
still not working. I am guessing that the same program may have disabled it.
Is there a VB immediate commande to re-enable it. When a chart is selected I
right mouse click to bring up all the options for the chart and can then
change the chart definitions. I don't believe this is a new feature.

I re-entered my problem because for some reason I am not getting any email
feedback advice - I did however, when you responded to me today. Also, when I
go into the community help area I was unable to display my question of
5/5/06. I have only been able to get the information by following the links
you supplied me in your reply.

Thanks for the CMB help, are you able to help me with the mouse problem?

Thanks
Alison

quot;Greg Wilsonquot; wrote:

gt; When you activate a chart the Worksheet Menu Bar (WMB) normally disappears
gt; and the Chart Menu Bar (CMB) takes its place. The CMB looks exactly the same
gt; except that it has a Chart menu in place of the Data menu. There is an
gt; illusion that the WMB remains and only the menu item changes.
gt;
gt; I'm guessing that the CMB has been docked, say, at the bottom of the window,
gt; and so when the WMB disappears and the CMB takes its place (at the bottom
gt; instead), it looks as though the WMB just disappeared. Alternatively, perhaps
gt; the CMB has been disabled. To my knowledge, you can only disable it
gt; programmatically:
gt; Application.CommandBars(quot;Chart Menu Barquot;).Enabled = False
gt;
gt; As for not being able to right mouse click, can you be more specific. I
gt; suspect this has to do with the new protection features available that I'm
gt; not up to date with. I'm running xl2000.
gt;
gt; Regards,
gt; Greg
gt;
gt; quot;Alisonquot; wrote:
gt;
gt; gt; I have a spreadsheet that I have been using for a couple of years but now
gt; gt; when I select a chart I lose my menu bar (file, edit, view etc). Also, I am
gt; gt; no longer able to right mouse click. If I select elsewhere on the sheet my
gt; gt; menu and mouse operations returns. Any help would be greatly appreciated. I
gt; gt; have tried resetting my worksheet menu bar by selecting tools/customise
gt; gt; toolbars but this doesn't help.


gt; I re-entered my problem because for some reason I am not getting any email
gt; feedback advice - I did however, when you responded to me today. Also,
gt; when I
gt; go into the community help area I was unable to display my question of
gt; 5/5/06. I have only been able to get the information by following the
gt; links
gt; you supplied me in your reply.

a. You shouldn't expect help direct from Microsoft. These forums are
quot;staffedquot; by volunteers who like helping people solve their problems.

b. The web interface is pretty lousy, even though they've improved it in
recent years. You can access the forums using a news reader (Outlook
Distress will suffice). Open a new account of type News, link to the news
server news:msnews.microsoft.com, and browse the list of news groups until
you find the relevant ones.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______
I am a new user to all this and at no time expected a response from
Microsoft. However, on entering the information it stated it would send me a
confirmation email in I think it said up to 10 minutes. Nothing came until
the next day. It also said that when someone responds it would send an email.
Greg responded but I still got no email. I also could not see my query when I
reentered the discussion group site. That is why after waiting a week I
reentered my query as I had noticed it is usually less than 24 hours to get a
response.

I still have problems with my mouse tho.

quot;Jon Peltierquot; wrote:

gt;
gt; gt; I re-entered my problem because for some reason I am not getting any email
gt; gt; feedback advice - I did however, when you responded to me today. Also,
gt; gt; when I
gt; gt; go into the community help area I was unable to display my question of
gt; gt; 5/5/06. I have only been able to get the information by following the
gt; gt; links
gt; gt; you supplied me in your reply.
gt;
gt; a. You shouldn't expect help direct from Microsoft. These forums are
gt; quot;staffedquot; by volunteers who like helping people solve their problems.
gt;
gt; b. The web interface is pretty lousy, even though they've improved it in
gt; recent years. You can access the forums using a news reader (Outlook
gt; Distress will suffice). Open a new account of type News, link to the news
gt; server news:msnews.microsoft.com, and browse the list of news groups until
gt; you find the relevant ones.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt;

You wouldn't have run some kind of macro that disabled chart functions? The
chart menu bar and the chart context menu both missing at once, that's more
than a coicidence.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Alisonquot; gt; wrote in message
news
gt;I am a new user to all this and at no time expected a response from
gt; Microsoft. However, on entering the information it stated it would send me
gt; a
gt; confirmation email in I think it said up to 10 minutes. Nothing came until
gt; the next day. It also said that when someone responds it would send an
gt; email.
gt; Greg responded but I still got no email. I also could not see my query
gt; when I
gt; reentered the discussion group site. That is why after waiting a week I
gt; reentered my query as I had noticed it is usually less than 24 hours to
gt; get a
gt; response.
gt;
gt; I still have problems with my mouse tho.
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt;
gt;gt; gt; I re-entered my problem because for some reason I am not getting any
gt;gt; gt; email
gt;gt; gt; feedback advice - I did however, when you responded to me today. Also,
gt;gt; gt; when I
gt;gt; gt; go into the community help area I was unable to display my question of
gt;gt; gt; 5/5/06. I have only been able to get the information by following the
gt;gt; gt; links
gt;gt; gt; you supplied me in your reply.
gt;gt;
gt;gt; a. You shouldn't expect help direct from Microsoft. These forums are
gt;gt; quot;staffedquot; by volunteers who like helping people solve their problems.
gt;gt;
gt;gt; b. The web interface is pretty lousy, even though they've improved it in
gt;gt; recent years. You can access the forums using a news reader (Outlook
gt;gt; Distress will suffice). Open a new account of type News, link to the news
gt;gt; server news:msnews.microsoft.com, and browse the list of news groups
gt;gt; until
gt;gt; you find the relevant ones.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt;
gt;gt;
Possibly received one from someone. Do you know what the VB command is to
turn back on the Chart Context Menu ( I have turned the Chart Menu bar back
on thru VB immediate.)
Thanks

quot;Jon Peltierquot; wrote:

gt; You wouldn't have run some kind of macro that disabled chart functions? The
gt; chart menu bar and the chart context menu both missing at once, that's more
gt; than a coicidence.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Alisonquot; gt; wrote in message
gt; news
gt; gt;I am a new user to all this and at no time expected a response from
gt; gt; Microsoft. However, on entering the information it stated it would send me
gt; gt; a
gt; gt; confirmation email in I think it said up to 10 minutes. Nothing came until
gt; gt; the next day. It also said that when someone responds it would send an
gt; gt; email.
gt; gt; Greg responded but I still got no email. I also could not see my query
gt; gt; when I
gt; gt; reentered the discussion group site. That is why after waiting a week I
gt; gt; reentered my query as I had noticed it is usually less than 24 hours to
gt; gt; get a
gt; gt; response.
gt; gt;
gt; gt; I still have problems with my mouse tho.
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; gt; I re-entered my problem because for some reason I am not getting any
gt; gt;gt; gt; email
gt; gt;gt; gt; feedback advice - I did however, when you responded to me today. Also,
gt; gt;gt; gt; when I
gt; gt;gt; gt; go into the community help area I was unable to display my question of
gt; gt;gt; gt; 5/5/06. I have only been able to get the information by following the
gt; gt;gt; gt; links
gt; gt;gt; gt; you supplied me in your reply.
gt; gt;gt;
gt; gt;gt; a. You shouldn't expect help direct from Microsoft. These forums are
gt; gt;gt; quot;staffedquot; by volunteers who like helping people solve their problems.
gt; gt;gt;
gt; gt;gt; b. The web interface is pretty lousy, even though they've improved it in
gt; gt;gt; recent years. You can access the forums using a news reader (Outlook
gt; gt;gt; Distress will suffice). Open a new account of type News, link to the news
gt; gt;gt; server news:msnews.microsoft.com, and browse the list of news groups
gt; gt;gt; until
gt; gt;gt; you find the relevant ones.
gt; gt;gt;
gt; gt;gt; - Jon
gt; gt;gt; -------
gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt;gt; Peltier Technical Services
gt; gt;gt; Tutorials and Custom Solutions
gt; gt;gt; PeltierTech.com/
gt; gt;gt; _______
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

My guess is that someone has created a Class Module that is set to the
embedded chart object and has set the Cancel parameter of the
BeforeRightClick event to True. In other words, they have deactivated the
right click event instead of disabling the popup commmand bars.

I would look for a Class Module that has code at the beginning something
like this where quot;mychartquot; could be any variable name:

Option Explicit
Public WithEvents mychart As Excel.Chart

Private Sub mychart_BeforeRightClick(Cancel As Boolean)
Cancel = True
'more code
End Sub

And also in a standard module code roughly like this where quot;Class1quot; is the
name of the Class Module:

Dim cht As New Class1
Sub xyz()
Set cht.mychart = ActiveSheet.ChartObjects(1).Chart
End Sub

I don't see a reason to be selective about the chart popups, so to re-enable
all commandbars:
For Each cb In Application.CommandBars
cb.Enabled = True
Next

Regards,
Gregquot;Alisonquot; wrote:

gt; Possibly received one from someone. Do you know what the VB command is to
gt; turn back on the Chart Context Menu ( I have turned the Chart Menu bar back
gt; on thru VB immediate.)
gt; Thanks
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt; gt; You wouldn't have run some kind of macro that disabled chart functions? The
gt; gt; chart menu bar and the chart context menu both missing at once, that's more
gt; gt; than a coicidence.
gt; gt;
gt; gt; - Jon
gt; gt; -------
gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; Peltier Technical Services
gt; gt; Tutorials and Custom Solutions
gt; gt; PeltierTech.com/
gt; gt; _______
gt; gt;
gt; gt; quot;Alisonquot; gt; wrote in message
gt; gt; news
gt; gt; gt;I am a new user to all this and at no time expected a response from
gt; gt; gt; Microsoft. However, on entering the information it stated it would send me
gt; gt; gt; a
gt; gt; gt; confirmation email in I think it said up to 10 minutes. Nothing came until
gt; gt; gt; the next day. It also said that when someone responds it would send an
gt; gt; gt; email.
gt; gt; gt; Greg responded but I still got no email. I also could not see my query
gt; gt; gt; when I
gt; gt; gt; reentered the discussion group site. That is why after waiting a week I
gt; gt; gt; reentered my query as I had noticed it is usually less than 24 hours to
gt; gt; gt; get a
gt; gt; gt; response.
gt; gt; gt;
gt; gt; gt; I still have problems with my mouse tho.
gt; gt; gt;
gt; gt; gt; quot;Jon Peltierquot; wrote:
gt; gt; gt;
gt; gt; gt;gt;
gt; gt; gt;gt; gt; I re-entered my problem because for some reason I am not getting any
gt; gt; gt;gt; gt; email
gt; gt; gt;gt; gt; feedback advice - I did however, when you responded to me today. Also,
gt; gt; gt;gt; gt; when I
gt; gt; gt;gt; gt; go into the community help area I was unable to display my question of
gt; gt; gt;gt; gt; 5/5/06. I have only been able to get the information by following the
gt; gt; gt;gt; gt; links
gt; gt; gt;gt; gt; you supplied me in your reply.
gt; gt; gt;gt;
gt; gt; gt;gt; a. You shouldn't expect help direct from Microsoft. These forums are
gt; gt; gt;gt; quot;staffedquot; by volunteers who like helping people solve their problems.
gt; gt; gt;gt;
gt; gt; gt;gt; b. The web interface is pretty lousy, even though they've improved it in
gt; gt; gt;gt; recent years. You can access the forums using a news reader (Outlook
gt; gt; gt;gt; Distress will suffice). Open a new account of type News, link to the news
gt; gt; gt;gt; server news:msnews.microsoft.com, and browse the list of news groups
gt; gt; gt;gt; until
gt; gt; gt;gt; you find the relevant ones.
gt; gt; gt;gt;
gt; gt; gt;gt; - Jon
gt; gt; gt;gt; -------
gt; gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt; gt;gt; Peltier Technical Services
gt; gt; gt;gt; Tutorials and Custom Solutions
gt; gt; gt;gt; PeltierTech.com/
gt; gt; gt;gt; _______
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
gt; gt;

Thanks Greg, I understand what you are saying but I just can't quite get the
right click to work, probably because I am not very familiar with VB. I can
get into the VB immediate screen but I have typed your all commandbars code
but it keeps coming up with errors. I was able to re-enable the Chart Menu
Bar this way. I know I am doing something wrong but I am not sure what. Hope
you can help this dummy.

Alison

quot;Greg Wilsonquot; wrote:

gt; My guess is that someone has created a Class Module that is set to the
gt; embedded chart object and has set the Cancel parameter of the
gt; BeforeRightClick event to True. In other words, they have deactivated the
gt; right click event instead of disabling the popup commmand bars.
gt;
gt; I would look for a Class Module that has code at the beginning something
gt; like this where quot;mychartquot; could be any variable name:
gt;
gt; Option Explicit
gt; Public WithEvents mychart As Excel.Chart
gt;
gt; Private Sub mychart_BeforeRightClick(Cancel As Boolean)
gt; Cancel = True
gt; 'more code
gt; End Sub
gt;
gt; And also in a standard module code roughly like this where quot;Class1quot; is the
gt; name of the Class Module:
gt;
gt; Dim cht As New Class1
gt; Sub xyz()
gt; Set cht.mychart = ActiveSheet.ChartObjects(1).Chart
gt; End Sub
gt;
gt; I don't see a reason to be selective about the chart popups, so to re-enable
gt; all commandbars:
gt; For Each cb In Application.CommandBars
gt; cb.Enabled = True
gt; Next
gt;
gt; Regards,
gt; Greg
gt;
gt;
gt; quot;Alisonquot; wrote:
gt;
gt; gt; Possibly received one from someone. Do you know what the VB command is to
gt; gt; turn back on the Chart Context Menu ( I have turned the Chart Menu bar back
gt; gt; on thru VB immediate.)
gt; gt; Thanks
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt; gt; You wouldn't have run some kind of macro that disabled chart functions? The
gt; gt; gt; chart menu bar and the chart context menu both missing at once, that's more
gt; gt; gt; than a coicidence.
gt; gt; gt;
gt; gt; gt; - Jon
gt; gt; gt; -------
gt; gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; gt; Peltier Technical Services
gt; gt; gt; Tutorials and Custom Solutions
gt; gt; gt; PeltierTech.com/
gt; gt; gt; _______
gt; gt; gt;
gt; gt; gt; quot;Alisonquot; gt; wrote in message
gt; gt; gt; news
gt; gt; gt; gt;I am a new user to all this and at no time expected a response from
gt; gt; gt; gt; Microsoft. However, on entering the information it stated it would send me
gt; gt; gt; gt; a
gt; gt; gt; gt; confirmation email in I think it said up to 10 minutes. Nothing came until
gt; gt; gt; gt; the next day. It also said that when someone responds it would send an
gt; gt; gt; gt; email.
gt; gt; gt; gt; Greg responded but I still got no email. I also could not see my query
gt; gt; gt; gt; when I
gt; gt; gt; gt; reentered the discussion group site. That is why after waiting a week I
gt; gt; gt; gt; reentered my query as I had noticed it is usually less than 24 hours to
gt; gt; gt; gt; get a
gt; gt; gt; gt; response.
gt; gt; gt; gt;
gt; gt; gt; gt; I still have problems with my mouse tho.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Jon Peltierquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; gt; I re-entered my problem because for some reason I am not getting any
gt; gt; gt; gt;gt; gt; email
gt; gt; gt; gt;gt; gt; feedback advice - I did however, when you responded to me today. Also,
gt; gt; gt; gt;gt; gt; when I
gt; gt; gt; gt;gt; gt; go into the community help area I was unable to display my question of
gt; gt; gt; gt;gt; gt; 5/5/06. I have only been able to get the information by following the
gt; gt; gt; gt;gt; gt; links
gt; gt; gt; gt;gt; gt; you supplied me in your reply.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; a. You shouldn't expect help direct from Microsoft. These forums are
gt; gt; gt; gt;gt; quot;staffedquot; by volunteers who like helping people solve their problems.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; b. The web interface is pretty lousy, even though they've improved it in
gt; gt; gt; gt;gt; recent years. You can access the forums using a news reader (Outlook
gt; gt; gt; gt;gt; Distress will suffice). Open a new account of type News, link to the news
gt; gt; gt; gt;gt; server news:msnews.microsoft.com, and browse the list of news groups
gt; gt; gt; gt;gt; until
gt; gt; gt; gt;gt; you find the relevant ones.
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt; - Jon
gt; gt; gt; gt;gt; -------
gt; gt; gt; gt;gt; Jon Peltier, Microsoft Excel MVP
gt; gt; gt; gt;gt; Peltier Technical Services
gt; gt; gt; gt;gt; Tutorials and Custom Solutions
gt; gt; gt; gt;gt; PeltierTech.com/
gt; gt; gt; gt;gt; _______
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt; gt;gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;