Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tools Bar
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tools Bar
Hi Julie
I have a example here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tools Bar
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tools key and add ins? | Excel Discussion (Misc queries) | |||
HELP! Where is the Tools tab?? | Excel Discussion (Misc queries) | |||
PA Tools Add In | Excel Discussion (Misc queries) | |||
Tools-Options | Excel Programming | |||
Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools | Excel Programming |