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

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.