Want custom toolbar to not be global

pilot · Apr 9th, 2002, 10:22 AM

Is it possible to attach a custom toolbar to a wb such that it is only visible and available when that wb is open?

If not, can that scenario be created through other means?

Chris Davison · Apr 10th, 2002, 02:24 PM

no replies, so I'll stick my oar in...

is the workbook also limited to a certain group of users ?

pilot · Apr 10th, 2002, 02:28 PM

Thanks Chris but I reposted earlier today and got an answer. It involved setting the "MyToolbar" visible attribute to false in the before close event.

Chris Davison · Apr 10th, 2002, 04:16 PM

I was just about to suggest that...

okie, important thing is you got it fixed.

Jack in the UK · Apr 10th, 2002, 04:32 PM

Hi

Pilot

Can i ask as you have a workable answer you post the feed thats answers thios so everyone can find the link (answer easy)

You have reposted, rather than stick on this feed and return to the top of the board, some guys minght no see this answer

Sure you understand... help others if you can mate!

pilot · Apr 11th, 2002, 06:01 AM

Good idea, Jack. Here's the boiled down version of the answer provided by TsTom and Mr Nick.

This should work.
Place it in your Workbook Deactivate and in the Close or before close:

Application.CommandBars("Your CommandBar").visible = False

Apr 10th, 2002, 04:32 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Pilot Can i ask as you have a workable answer you post the feed thats answers thios so everyone can find the link (answer easy) You have reposted, rather than stick on this feed and return to the top of the board, some guys minght no see this answer Sure you understand... help others if you can mate! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 10:22 AM	#1
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	Is it possible to attach a custom toolbar to a wb such that it is only visible and available when that wb is open? If not, can that scenario be created through other means?

Apr 10th, 2002, 02:24 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	no replies, so I'll stick my oar in... is the workbook also limited to a certain group of users ?

Apr 10th, 2002, 02:28 PM	#3
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	Thanks Chris but I reposted earlier today and got an answer. It involved setting the "MyToolbar" visible attribute to false in the before close event.

Apr 10th, 2002, 04:16 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	I was just about to suggest that... okie, important thing is you got it fixed.

Apr 11th, 2002, 06:01 AM	#6
pilot Board Regular Join Date: Feb 2002 Location: Houston, TX Posts: 303	Good idea, Jack. Here's the boiled down version of the answer provided by TsTom and Mr Nick. This should work. Place it in your Workbook Deactivate and in the Close or before close: Application.CommandBars("Your CommandBar").visible = False