Toolbar should not load at startup

[sharkfoot]

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:

Please Login or Register  to view this content.

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?

[bigwheel]

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

[sharkfoot]

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]

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

[bigwheel]

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

[sharkfoot]

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

They are seperate