Turning off a Toolbar

B

Blondie

I have created a custom toolbar and associated it to a specific form. I can
get the toolbar to open when the form is opened, but can't seem to find a way
to turn it off when I close the form. Any help would be great.
 
J

Jim Rech

I have created a custom toolbar and associated it to a specific form.

I think you mean you attached it to a workbook. You have to use code to
close the toolbar when the workbook closes. Put this in a standard module:

Sub Auto_Close()
Commandbars("YourToolbarNameHere").Delete
End Sub
--
Jim
|I have created a custom toolbar and associated it to a specific form. I
can
| get the toolbar to open when the form is opened, but can't seem to find a
way
| to turn it off when I close the form. Any help would be great.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top