View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Tool drop down and right click choices are missing

Try ViewToolbarsCustomizeToolbars.

Select the Worksheet Menu Bar and "reset".

For the right-click menu.............

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


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 13:26:01 -0800, Bozo wrote:

I am using Office 2003.
I didn't have any choices when I click on Tools on the menu bar. I went to
customize the toolbar (View,Toolbars,Customize-Commands tab, Rearrange
Commands button and Add controls to the Tools menu bar).
It is adding them but... what could have caused this to happen.

Additionally, I have a similar problem. I right click within a cell and I
get nothing but an empty square box with no options.

I have repaired, uninstalled and reinstalled and still have the same results.