Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|