Right mouse Clicking

[Guest]

Help
Using Excel 2003. Yesterday when I was in any cell and did a right mouse
click I would get all sorts of options (Cut, Paste, Format, Column width,
etcc). Now I only get cut and paste. Where can I reset this.
Thanks

 

[Gord Dibben]

Are the other menu items there but just not available as in "grayed out"?

Your worksheet may be protected.

Tools>Protection>Unprotect Sheet.

Are the items missing completely?

You can try to reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Cell").Enabled = True

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub


Gord Dibben MS Excel MVP

Help
Using Excel 2003. Yesterday when I was in any cell and did a right mouse
click I would get all sorts of options (Cut, Paste, Format, Column width,
etcc). Now I only get cut and paste. Where can I reset this.
Thanks

Gord Dibben MS Excel MVP

 

[Ron de Bruin]

Typo

Now I only get cut and paste

Change Gord's code to

Application.CommandBars("Cell").Reset

 

[Gord Dibben]

Thanks for the correction Ron.

These canned responses can lead to some interesting "typos".


Gord