Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Turning off a Toolbar

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   Report Post  
Posted to microsoft.public.excel.misc
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keeps turning off rio Excel Worksheet Functions 4 August 31st 07 02:08 AM
Turning 0.000 values red bz Excel Worksheet Functions 2 April 1st 06 12:49 PM
Adjusting toolbar size, restore toolbar Josh M Excel Discussion (Misc queries) 1 January 18th 06 06:17 PM
Turning #N/A to a zero...?? bigtim Excel Discussion (Misc queries) 5 July 26th 05 08:48 PM
Turning off Template Help Brentnik Excel Discussion (Misc queries) 0 April 12th 05 03:08 AM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"