How do i remove a toolbar from excel 2007?

[Stefano]

My VBA add-ins create one or more toolbars.
In Excel 2003 I could keep visible the toolbars that I use and hide the
toolbars that I don't use with a simple right click on any toolbar and then a
click on the toolbar name. I could also remove the toolbars that I didn't
need anymore from the customize dialog box.
In Excel 2007 I have the Add-Ins tab full of toolbars, and I don't know how
to hide or delete them (the add-ins are not anymore installed, so the
toolbars are useless and deletable).

 

[Ron de Bruin]

Hi Stefano

Close Excel
Do a search for Excel12.xlb on you machine (in a hidden folder)

Delete or rename this file

Try again

 

[shah shailesh]

You can right click on each unwanted Toolbar in the Addins Tab & select
delete custom toolbar.


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[challa prabhu]

Hi,

Do one of the following:

On the View menu, point to Toolbars, and then any selected Toolbar to make
them invisible on the application interface.

-or-

1. Rignt on the Toolbar and then Customize.
The Customize dialog is displayed.
2. Click the Toolbars Tab.
3. Clear the selection of any Toolbar check box.
4. Click Close button to return the application. The application does not
show the Toolbar now.

-or-

1. Move your pinter to the Left of the Tool. The mouse pointer changes to a
pointer with "four direction arrows".
2. Click and drag the Toolbar into the Workspace
3. Click the close icon (X) to delete the toolbar from the interface.

Challa Prabhu

 

[Stefano]

Thank you, now I know how to delete an old toolbar.
Is there any way to hide a toolbar without deleting it?

Stefano

 

[Stefano]

Are you talking about Excel 2003 or 2007?

Hi,

Do one of the following:

On the View menu, point to Toolbars, and then any selected Toolbar to make
them invisible on the application interface.

-or-

1. Rignt on the Toolbar and then Customize.
The Customize dialog is displayed.
2. Click the Toolbars Tab.
3. Clear the selection of any Toolbar check box.
4. Click Close button to return the application. The application does not
show the Toolbar now.

-or-

1. Move your pinter to the Left of the Tool. The mouse pointer changes to a
pointer with "four direction arrows".
2. Click and drag the Toolbar into the Workspace
3. Click the close icon (X) to delete the toolbar from the interface.

Challa Prabhu

 

[shah shailesh]

Hi Stefano,


With VBA code use,


Toolbars("My Toolbar Name").Visible = True


Otherwise you can use my free addins to hide\unhide the toolbars as you do
in previous version. i.e. View>Toolbars>select the toolbar. BTW You can't
Customize the toolbars.

Download this addin from Addins page of below site

http://in.geocities.com/shahshaileshs/

choose Excel Menu 2003.

1. This Addin need to load only for the first time.
2. It installed Worksheet Menubar, Standard Toolbar and Formatting Toolbar
in the Addins Tab inside the Ribbon.
3. The File Size is only about 20 kb.


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[shah shailesh]

Hi Stefano,

Note that this is applicable only to custom toolbars as also with my free
addins "Excel Menu-2003 for Excel 2007".

To hide
Toolbars("My Custom Toolbar Name").Visible = False

to unhide
Toolbars("My Custom Toolbar Name").Visible = True

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[challa prabhu]

Hi,

Sorry, I was referring to Excel 2003. However, I found a topic in the
on-line help of 2003 - Load or unload add-in programs.

In the add-ins available we can only clear or select the addins checkboxes
once it is installed.

Challa Prabhu