Right Mouse Click not Working in Excel RRS feed

  • Question


    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?
    Sunday, March 23, 2008 12:37 PM

All replies

  • 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
    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





    Wednesday, March 26, 2008 5:48 PM
  • 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?


    Thursday, March 27, 2008 4:12 AM
  • Thanks for your help, this solution solved my excel problems.....

    Tuesday, October 7, 2008 11:42 PM