locked
Right Mouse Click not Working in Excel

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

     

     

     

     

    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 07, 2008 11:42 PM