is it possible to disable commandbar attach?

[Emjaye]

Is it possible to disable the ability to "Attach" toolbars to a workbook?
I've a toolbar/commandbar created 'on the fly' when the workbook activates, (deleted on deactivate)...
Just curious to see if it is possible to stop it being attached to the workbook? I don't know how to disable this..

thanks.

 

[Oorang]

You coul dmake it start msofloating. But they could still drag it to the workbook wall. I don't think you can disable the attachability of it. You would probablly want to go with a user form for that. Out of curiousity...Why would would want to prevent it from docking?

 

[Emjaye]

Thanks Oorang, but I haven't clarified it too well!

I don't mean to disable the "docking" or floating ability ... can do that by .msobarnocustomize.

I meant how to disable "saving" (attaching) a commandbar to a workbook when the workbook is saved

i.e. disable the path > View/Toolbars/Customize/('toolbars' tab) Attach/Copy

preferably for a specific commandbar rather than en-mass, with something I suspect, along the lines of a MSOBAR instruction?

thanks

 

[Oorang]

I meant how to disable "saving" (attaching) a commandbar to a workbook when the workbook is saved

Set ICB = Application.CommandBars.Add(Name:="iClear Console", Temporary:=True)

 

[Emjaye]

Sorry, this isn't working for me.... (Using Excel XP and also 2003).
Other thoughts gratefully received.

 

[Oorang]

I think maybe I'm still not clear on what you are wanting. And what you mean be "attaching"

 

[Emjaye]

Hi Oorang, apologies for the delay in coming back...

I am looking for something to apply to an individual, specified Commandbar ... in a similar fashion by which it is possible to prevent customisation of a single Commandbar by using the command:

 Application.Commandbars("MyBar").Protection = msoBarNoCustomize

However this does not prevent the User from accessing Standard (Excel) Customise menu, from which they can navigate and locate a 'custom' commandbar and then Attach (or effectively save) that commandbar with the workbook file; therefore, that "saved" commandbar loads everytime the workbook is opened, even when macro are disabled... this is my main motivation for preventing it from being possible.

I know it is possible to disable the customisation of all commandbars by applying the command:

Application.CommandBars.DisableCustomize = True

but I'm not too keen to do that, I will do so if needbe though

cheers, Mike

 

[Oorang]

Ahhhh!!!! Now I know EXACTLY what you are talkign about. When you create the code for your bar, use Temporary:=TRUE. Even if they attach the bar to the workbook, save and close. When you come back the bar will not be there.