One possible cause of this could be that the menu that appears on a
worksheet when you right click has been disabled.
Open a new blank workbook.
Open up the visual basic editor (Alt+F11). Insert a new module
Type the following code
Sub Reset()
With Application.CommandBars("Cell")
.Reset
.Enabled = True
End With
End Sub
Run this code and see if the right click menu comes back.
Nick
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.
