LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
sharkfoot
 
Posts: n/a
Default Toolbar should not load at startup


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving custom toolbars with macros to work on other computers jpw48 Excel Discussion (Misc queries) 11 August 29th 07 01:09 AM
Unable to load files from alternate startup folder Bill.Carlson Excel Discussion (Misc queries) 3 November 24th 05 03:36 PM
Forcing Excel to Load Below Office Toolbar Bill Helbron Excel Discussion (Misc queries) 2 October 2nd 05 04:09 PM
Toolbar problem Anthony Excel Discussion (Misc queries) 1 June 1st 05 01:05 AM
How do I remove reviewing toolbar from startup Cordovan Setting up and Configuration of Excel 1 May 24th 05 07:05 PM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"