Help with shortcut menu in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top