Right click on rows and columns does not give menu

  • Thread starter Thread starter RSolti
  • Start date Start date
R

RSolti

When I right click on the row numbers and column letters, I do not get the
menu pop up. I had the same issue with not being able to right click on
cells and tabs - but got those fixed by resetting code in VBE. Does anyone
know code to fix the rows and column menu?
 
Try this.

Sub asdfgh()
Application.CommandBars("column").Reset
Application.CommandBars("row").Reset
End Sub


Gord Dibben MS Excel MVP
 
This enables all commandbars/menus:

Sub EnableAllCBs()
Dim CB As CommandBar
For Each CB In CommandBars
CB.Enabled = True
Next
End Sub


--
Jim
| When I right click on the row numbers and column letters, I do not get the
| menu pop up. I had the same issue with not being able to right click on
| cells and tabs - but got those fixed by resetting code in VBE. Does
anyone
| know code to fix the rows and column menu?
 
Back
Top