short cut menu doesn't show when right click on mouse

Y

Yong Wah

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.
 
J

Jim Rech

Some app may have disabled it. You can run this macro to reverse that:

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

Tom Ogilvy

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.
 

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

Top