can't right click in excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 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
 
I tried that, but it did not work.

Thank you.

Gord Dibben said:
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 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
Click to expand...
 
Back
Top