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

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

 

[Jim Rech]

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

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

 

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