View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default cannot right-click a shortcut menu in Excel

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

Thanks again,

"Dave Peterson" wrote:

Try one mo

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

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

John wrote:

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

Any other ideas?

"Gord Dibben" wrote:

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 ViewImmediate 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


On Sat, 7 Apr 2007 10:40:04 -0700, John wrote:

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?



--

Dave Peterson