| 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 | |||
Linear Mode
