Want custom toolbar to not be global

[pilot]

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]

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

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

 

[pilot]

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]

I was just about to suggest that...

:wink:


okie, important thing is you got it fixed.

 

[Jack in the UK]

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]

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