Right click on rows and columns does not give menu

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?
 
G

Gord Dibben

Try this.

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


Gord Dibben MS Excel MVP
 
J

Jim Rech

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

delete on right click menu disabled 2
Right click mouse menu for insert does not work 2
rows and columns on worksheet 1
organizing rows and columns by text 1
Shortcut menu won't appear when I click right mouse button. 3
Re: cannot right-click a shortcut menu in Excel 1
copying some rows and columns 21
Expand and Shrink Rows and columns to hide information. 1

Top