can't right click in excel spreadsheet

[AMC]

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.

 

[Gord Dibben]

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

 

[AMC]

I tried that, but it did not work.

Thank you.

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

 

[Dave Peterson]

Is one of those addins essbase?

I don't use it, but Nigel posted this:

http://groups.google.co.uk/group/mi...32693214bf7?lnk=st&q=&rnum=1#0668432693214bf7
or
http://snipr.com/1nul6

===This is snipped from his post===

Go to the essbase menu and select options

Go to the global tab and deselect enable Secondary Button and enable Double
clicking

select OK

Essbase Hijacks those function, to reset it for essbase use, do the opposite
of above.