Forum Discussion

Emil Garnev's avatar
Emil Garnev
Copper Contributor
Jun 15, 2018
Solved

Mouse right click pop-up menu stopped working in Excel 2013

Hello,

I am using Excel for a long time. Since 2 days (probably I did some wrong shortcut key combination??) I cannot open pop-up menu with right click of the mouse.

Right click works everywhere in the menus and icons of Excel, even if I select full row or column still works, but in the area where are all cells it is not functional. Independent if it is existing excel book or new one. Still, if I open new Macro sheet within the book, it works there.

I tried restarting, also found few tips to write in VB some commands, but still no effect! 

Thank you for any support solving this annoying problem!

Emil

  • Open the VBA editor (alt+F11), press control+g. Type this text:
    Application.CommandBars("Cell").Reset
    At the end of that line, press enter.
    If that does not help, repeat the above with:
    Application.CommandBars("Cell").enabled=true

24 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Open the VBA editor (alt+F11), press control+g. Type this text:
    Application.CommandBars("Cell").Reset
    At the end of that line, press enter.
    If that does not help, repeat the above with:
    Application.CommandBars("Cell").enabled=true
    • leonard333's avatar
      leonard333
      Copper Contributor
      This worked for me in that I can now right-click on a cell. However, right-click is not working within the formula bar or if a column is selected. Is there another CommandBars reset/enable option that will fix this?
      • marcel_dima's avatar
        marcel_dima
        Copper Contributor

        Hi cauditrana 

         

        Vijay's first suggestion at this link worked for me: https://answers.microsoft.com/en-us/msoffice/forum/all/mouse-right-click-not-working-in-excel-sheets/74f65a2c-4a2b-4fc0-b29c-69c4d258a3a1

         

        Basically close Excel > navigate to "%appdata%\Microsoft\Excel" > move the files to a back up folder > relaunch Excel. 

Resources