Right Mouse Click not Working in Excel

Sunday, March 23, 2008 12:37 PM

0

Iam using Excel 2007 with XP and have been doing so ever since I got my new Dell Latitude D630 Laptop a few months ago. Everything was working fine until a few days ago when my right mouse button ceased to work in Excel. It works fine in everything else (Word, Outlook, Powerpoint etc) just Excel. It doesn't matter if I use the touch pad, a mouse (I have tried several) or hot key button nothing seems to work. I even tried re-installing MS Office but still no right click in Excel. I am getting very frustrated - can anyone help me please?

Wednesday, March 26, 2008 5:48 PM

0

Just had this problem fixed for me. - No idea how it got into that state though.

First open Excel and hit "Alt + F11" This will bring up the VBEditor.

From the Menu select Insert -> Module and then copy the following code:

Sub Enable_All_Right_Click_Menus()
'This will enable all BuiltIn Command bars
Dim Cbar As CommandBar
For Each Cbar In Application.CommandBars
Cbar.Enabled = True
Next
End Sub

Then hit F5 (or select run from the menu)

Close the VBEditor.

Should work fine now.

Found this solution at http://www.eggheadcafe.com/software/aspnet/29685542/cannot-rightclick-a-shor.aspx
Thursday, March 27, 2008 4:12 AM

0

Thank you yes it works, however each time I open a spreadsheet I have to go through this process. Is that what you have to do?
Tuesday, October 07, 2008 11:42 PM

0

Thanks for your help, this solution solved my excel problems.....