Tools Bar

J

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
 
B

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
 
Top