Forum Discussion

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

excel

JKPieterse
Jun 15, 2018
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

Copper Contributor

Apr 28, 2022

Any workbook. I managed to get the formula bar, column. and row working buy using the method:
Application.CommandBars("Cell").Reset
Application.CommandBars("Cell").enabled=true

- replacing "cell" with "formula bar" etc. It worked for formula bar, row, and column. But worksheet tabs and vba buttons, nope. This is very weird. Btw I'm using Excel 2010.

JKPieterse

Silver Contributor

Apr 29, 2022

leonard333 Here's a macro to reset all commandbars:

Sub ResetBars()
    Dim bar As CommandBar
    On Error Resume Next 'Avoids errors
    For Each bar In Application.CommandBars
        bar.Reset
    Next
End Sub

leonard333
Copper Contributor
Apr 29, 2022
Didn't work at first, but changed "bar.Reset" to
"bar.Reset
bar.Enabled = True"
Everything is back to normal! Thank you very much.