My right click context menu stopped working in Excel 2007 all of a sudden. It was driving me nuts. The Excel context menu wouldn’t display.
I came across the solution, which seems to be an absurd on, but it worked.
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
Type this and hit enter:
then the same with this line:
application.CommandBars("cell").Enabled = True
Hit alt-f11 to get back to excel and test it out.
I am quite impressed someone found this solution, but also trying to figure out how in the world this happened in the first place.