can't right click in excel spreadsheet
 

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.

can't right click in excel spreadsheet
 

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.

can't right click in excel spreadsheet
 

I tried that, but it did not work.

Thank you.

"Gord Dibben" wrote:

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.

can't right click in excel spreadsheet
 

Is one of those addins essbase?

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

http://groups.google.co.uk/group/mic...68432693214bf7
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.


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.

--

Dave Peterson