Help with shortcut menu in Excel

H

Helen

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!
 
G

Gord Dibben

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