Great help, Mike. Now maybe I can get this albatross out of my hair.
Thanks for your time.
Jack

"mike" wrote:

Actually there is. Your toolbar will remain unless you programmatically
remove it. I would recommend activating the toolbar on open as removing
it on close.

In Auto_Open add the following just before you end the sub

Set myBar = CommandBars("toolbar_name")
myBar.Enabled = True

In Auto_Close add the following

Set myBar = CommandBars("toolbar_name")
myBar.Enabled = False