Help with shortcut menu in Excel
Helen
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 Wed, 14 Feb 2007 11:41:02 -0800, Helen
wrote:
Good day,
A user has brought the following to my attention: whenever he right-clicks
a cell, there is no shortcut menu. Instead, he gets an empty white box,
regardless if the cell contains data or not.
This happened after he opened an Excel file found on our Intranet site.
Could there be a macro in there? And what is worse is that this happens in
all his Excel documents.
Excel 2003.
Thank you!
|