Forum Discussion
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
- JKPieterseSilver ContributorOpen 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- leonard333Copper ContributorThis 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?
- leonard333Copper Contributor
solved. Repeated using "column" and "formula bar". leonard333
- a8a8uCopper ContributorIt worked. Thank you!
- cauditranaCopper Contributor
tried with both the options, nothing worked for me, please help
- marcel_dimaCopper 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.