cannot right-click a shortcut menu in Excel

[Guest]

I can no longer get short-cut menus by right clicking on cells or charts in
Excel 2003. (right clicking does work in other office applications such as
powerpoint, so I have ruled out a hardware problem) I do not have a symbol
commander installed. Restarting the computer does not work. The problem
seemed to occur after I used the symbol insert feature of excel. Any ideas
for me?

 

[Gord Dibben]

John

If no menu appears with a right-click you shoud try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Cell").Reset

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP

 

[Guest]

Thank you Gord Dibben. However running the macro did not correct the
situation -- still no menu on right-click.

Any other ideas?

 

[Dave Peterson]

Try one more:

Application.CommandBars("Cell").enabled = true

Either directly in the immediate window -- or in the procedure.

 

[Guest]

Thank you Dave Peterson. That corrected the problem. You made my Saturday!!

Thanks again,

 

[Gord Dibben]

Thanks for jumpling in Dave.


Gord

Try one more:

Application.CommandBars("Cell").enabled = true

Either directly in the immediate window -- or in the procedure.

 

[Dave Peterson]

You're welcome, Gord.

(I just hope that "jumpling" is a good thing <vbg>.)

 

[Gord Dibben]

jumpling has never caused me any harm but like anything else, should be used
only in moderation.

 

[Guest]

After using excel again, I realized that the previous macro did turn on the
menus for cells but did not turn back on the short cut menus for rows,
columns and charts. With a little digging I came up with the following macro
that appears to have enabled all the right-click shortcut menus.

Sub Enable_All_Right_Click_Menus()
'This will enable all BuiltIn Command bars
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
Next
End Sub

Thanks Gord and Dave for setting me in the right direction.

 

[Gord Dibben]

Thanks for the feedback John.

Good job of digging.


Gord

 

[Mayur Shetty]

Go to Task Manager and search for Verclsid and end task.
Then go to C:\Windows and search for the same file and rename it (Verclsidold).
Re-open Excel and it should work.
If that does not work perform the below steps :-
*Excel11.xlb [D:\Documents and Settings\username\Application Data\Microsoft\Excel], remove the file and save it in a different location
{Eg:-desktop}.
* Reopen excel and excel11.xlb gets created.[Delete the previous excel11.xlb once you confirm from user its all working fine]

*unregister and register excel
[Unregister - Start- run - excel /unregsvr, Register - excel /regsvr]



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com