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
|