If no menu appears with a right-click you should try re-setting the r-click.

Hit ALT + F11 to go to the VBEditor.

Then ViewImmediate 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


On Tue, 26 Jun 2007 08:56:02 -0700, AMC wrote:

Hello,

I am using Excel 2000 and had to load a couple of non-excel add-ins for the
job. I am now unable to right-click in the work area, but I'm not sure that
the right click feature worked before the add-ins because I'm new and had not
used the computer before. I use the feature a lot to add comments or copy
and paste and I can no longer do that. I searched the questions here, and
saw two that had different solutions. I tried the solutions, restarted my
computer, but I still don't get a menu when I right click on a cell.

Other people here have to use the same add-ins and they still have the right
click feature. Any ideas?

Thanks.