Tools Bar

[Julie]

Can anyone give me a code for closing all tool bars in
one go, and restoring to original state without entering
seperately one at a time?
Many thanks in advance
Julie

 

[Ron de Bruin]

Hi Julie

I have a example here
http://www.rondebruin.com/menuid.htm

 

[Bob Flanagan]

Julie, you can also do it this way:

For each cBar in application.commandbars
cbar.enabled = false
Next

and to re-activate,
For each cBar in application.commandbars
cbar.enabled = true
Next

If a toolbar is not enabled, it is not visible.

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel