ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   short cut menu doesn't show when right click on mouse (https://www.excelbanter.com/excel-programming/280123-short-cut-menu-doesnt-show-when-right-click-mouse.html)

Yong Wah

short cut menu doesn't show when right click on mouse
 
Hi
Would be grateful if someone could help on this.

Recently I upgrade from Excel 2000 to the XP version. However, when I right
click as usual, the short menu menu (with cut, copy, paste, insert...) did
not appear.

Is there any way I could activate back the menu when I right click the
mouse?

Thanks a million.





Jim Rech

short cut menu doesn't show when right click on mouse
 
Some app may have disabled it. You can run this macro to reverse that:

Sub a()
CommandBars("Cell").Enabled = True
End Sub


--
Jim Rech
Excel MVP



Tom Ogilvy

short cut menu doesn't show when right click on mouse
 
go to the VBE (Alt+F11)

do Insert=Module

paste in this code

Sub EnableCell()
With Application
.Commandbars("Cell").Reset
.Commandbars("Cell").Enabled = True
End With
End Sub

Then go back to Excel ( Alt+F11)

go to tools =Macro=Macros, select EnableCell and click Run.


Unless you have some code that is actively disabling it, it should work.

--
Regards,
Tom Ogilvy

"Yong Wah" wrote in message
...
Hi
Would be grateful if someone could help on this.

Recently I upgrade from Excel 2000 to the XP version. However, when I

right
click as usual, the short menu menu (with cut, copy, paste, insert...) did
not appear.

Is there any way I could activate back the menu when I right click the
mouse?

Thanks a million.








All times are GMT +1. The time now is 01:10 AM.

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