ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with shortcut menu in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/130726-help-shortcut-menu-excel.html)

helen

Help with shortcut menu in Excel
 
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!

Gord Dibben

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!




All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com