Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"