Thread: Toolbars
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Toolbars

That's my opinion too.. Workbook_Open / _Close and Temporary for all.

Quick question: do the controls need to be Temporary if it's commandbar is
already?

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bob Phillips" wrote in message
...
IMO temporary should be used for all custom commandbars, addin or not,

that
are created on open.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rob van Gelder" wrote in message
...
Jacob,

Examples of commandbars on my website.
Note the use of Temporary, which is the way you want to go if you're

using
Add-In Open/Close events.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jacob" wrote in message
...
I created a custom toolbar in excel and now I want to
share it with other users. I want this toolbar to open by
default everytime excel opens. Any ideas?

I've researched this and have been playing with using
personal.xls and know that the toolbars are stored in the
excel.xlb.

Thanks,
Jacob