View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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!