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

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.

Forum Discussion

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