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
"Julie" wrote in message
...
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