Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() I have a couple of custom toolbars, one of which is coded to load automatically when opening the workbook. The other should only come up with a button, which works fine, but it also loads at startup and no matter what I do I can't keep it from showing up when the workbook opens. Here is what I currently have: Code: -------------------- Sub Auto_Open() Toolbars("TNT Toolkit").Visible = True End Sub Sub Auto_Close() Toolbars("TNT Toolkit").Delete Toolbars("WOFC Menu").Delete Toolbars("AlSTH Menu").Delete End Sub -------------------- They all delete just fine, but the *ALSTH Menu* toolbar opens when the workbook opens and is giving me a headache. What do I do to keep it closed? -- sharkfoot ------------------------------------------------------------------------ sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164 View this thread: http://www.excelforum.com/showthread...hreadid=525747 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving custom toolbars with macros to work on other computers | Excel Discussion (Misc queries) | |||
Unable to load files from alternate startup folder | Excel Discussion (Misc queries) | |||
Forcing Excel to Load Below Office Toolbar | Excel Discussion (Misc queries) | |||
Toolbar problem | Excel Discussion (Misc queries) | |||
How do I remove reviewing toolbar from startup | Setting up and Configuration of Excel |