Tool drop down and right click choices are missing
 

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.

--
Bozo

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.

Tool drop down and right click choices are missing
 

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


"Gord Dibben" wrote:

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.

Tool drop down and right click choices are missing
 

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


"Gord Dibben" wrote:

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.

Tool drop down and right click choices are missing
 

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

On Wed, 1 Nov 2006 03:59:01 -0800, Bozo wrote:

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