Right Click / Shortcut Menu

  • Thread starter Thread starter Margus
  • Start date Start date
M

Margus

When I right click in Excel the shortcut menu doesn't
appear... what can I do to make this happen again?

Thanks.
 
Margus

Perhaps it has been disabled through code?

Try this in the VBE Immediate Window to reset it.

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

A toggle on/off macro...........

Sub RightClick_Menu_Toggle()
If Application.CommandBars("Cell").Enabled = True Then
Application.CommandBars("Cell").Enabled = False
Else
Application.CommandBars("Cell").Enabled = True
End If
End Sub

Gord Dibben Excel MVP
 
Back
Top