Right Click / Shortcut Menu

M

Margus

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

Thanks.
 
G

Gord Dibben

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
 

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