View custom toolbar?

[Stu]

Is it possible to make a custom toolbar to disappear on certain sheets of a
workbook or does it have to stay there?

Thanks

 

[Tom Ogilvy]

You would have to use the workbook events to hide the toolbar and make it
re-appear.

 

[Stu]

And I would do that how?


--
Thanks
--
Stu

You would have to use the workbook events to hide the toolbar and make it
re-appear.

--
Regards,
Tom Ogilvy

Is it possible to make a custom toolbar to disappear on certain sheets

of

 

[Tom Ogilvy]

Start here:

http://www.cpearson.com/excel/events.htm

Seems like I gave you a big group of references on programming commandbars.
Take a look at them.

--
Regards,
Tom Ogilvy

And I would do that how?

 

[Stu]

So how do I know what to call the toolbar in VB because I can probably do
everything else (except hide it, unless it is '.hidden = true' then I can do
that).

 

[Tom Ogilvy]

Look in Tools=>Customize, how is it listed there. That is it's name

Application.Commandbars("custom 1").Visible = False

as an example.