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

Toolbar should not load at startup
 

Where is the *ALSTH Menu* defined?
Would Toolbars("ALSTH Menu").Visible = False stop it from showing?

"sharkfoot" wrote:


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

Toolbar should not load at startup
 

bigwheel Wrote:
Where is the *ALSTH Menu* defined?
Would Toolbars("ALSTH Menu").Visible = False stop it from showing?


I've tried the =false thing to no avail. Not sure what you mean by
"where is the toolbar defined" but it's a custom toolbar created using
excel. Is that what you meant?


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=525747

Toolbar should not load at startup
 

Does no one know how to fix this problem? I'm stuck. :(


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=525747

Toolbar should not load at startup
 

Is it coded in the same Sub as the other menus or in a separate one?

"sharkfoot" wrote:


bigwheel Wrote:
Where is the *ALSTH Menu* defined?
Would Toolbars("ALSTH Menu").Visible = False stop it from showing?


I've tried the =false thing to no avail. Not sure what you mean by
"where is the toolbar defined" but it's a custom toolbar created using
excel. Is that what you meant?


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=525747

Toolbar should not load at startup
 

bigwheel Wrote:
Is it coded in the same Sub as the other menus or in a separate one?

They are seperate


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=525747