ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   No Menu functions/options when right clicking mouse (https://www.excelbanter.com/excel-discussion-misc-queries/228993-no-menu-functions-options-when-right-clicking-mouse.html)

Rob

No Menu functions/options when right clicking mouse
 
When I right click on the mouse button in excel, I no longer see any
functions/menus come available (no copy, paste, etc.). Was wondering how I
might fix this? Oh and I don't experience this probelm with any other
microsoft application (word, access, etc.) the right mouse funtionality still
works in these progrmas.

Dave Peterson

No Menu functions/options when right clicking mouse
 
When you rightclick on a cell in a worksheet?

If yes...

Open excel
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

Type this:
Application.CommandBars("Cell").enabled = True
and hit enter

Then type this:
Application.CommandBars("Cell").Reset
then hit enter

Then back to excel to test.



Rob wrote:

When I right click on the mouse button in excel, I no longer see any
functions/menus come available (no copy, paste, etc.). Was wondering how I
might fix this? Oh and I don't experience this probelm with any other
microsoft application (word, access, etc.) the right mouse funtionality still
works in these progrmas.


--

Dave Peterson


All times are GMT +1. The time now is 03:12 PM.

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