Tool drop down and right click choices are missing

[Bozo]

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.

 

[Gord Dibben]

Try View>Toolbars>Customize>Toolbars.

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


Gord Dibben MS Excel MVP

 

[Bozo]

Thanks Gord. I'll give it a try.
--
Bozo

Try View>Toolbars>Customize>Toolbars.

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


Gord Dibben MS Excel MVP

 

[Bozo]

Gord,
The VB Editor commands did not work.
Thanks anyhow.

 

[Gord Dibben]

Try this....

Close Excel.

Do a file search on your computer for *.XLB

When found, rename to *.OLD

There may be more than one *.XLB file............rename as above with a unique
fake extension.

Re-open Excel.............any luck?


Gord