Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keeps turning off | Excel Worksheet Functions | |||
Turning 0.000 values red | Excel Worksheet Functions | |||
Adjusting toolbar size, restore toolbar | Excel Discussion (Misc queries) | |||
Turning #N/A to a zero...?? | Excel Discussion (Misc queries) | |||
Turning off Template Help | Excel Discussion (Misc queries) |