Format drop down option won't open on selected cells
 

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

Format drop down option won't open on selected cells
 

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 ViewImmediate 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


On Thu, 12 Oct 2006 13:09:02 -0700, Ron West
wrote:

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