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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Right click mouse menu for insert does not work 2
delete on right click menu disabled 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
rows and columns on worksheet 1
I cannot delete the extra rows or columns in Excel 2007 2
Shortcut menu won't appear when I click right mouse button. 3
Autofit Row Height 4
Re: cannot right-click a shortcut menu in Excel 1

Back
Top