View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Turning off a Toolbar

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
"Blondie" wrote in message
...
|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.