Format drop down option won't open on selected cells

R

Ron West

When I select a certain cell to format the border or number, the drop down
"format" menu does not show.
 
G

Gord Dibben

Ron

Are you saying the right-click menu does not open?

You can reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Cell").Enabled = True

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub

If something else, hang around. Someone will come up with an alternate plan.


Gord Dibben MS Excel MVP
 
Top