Creating ustom toolbar

[David C]

Hi,

I am developing a workbook and have three basic functions to perform using
VB. Each of these functions I want the user to run simply by clicking on a
custom button located on a custom toolbar. I have this set up and working
well on my computer, but how do I get the toolbar and associated buttons to
be stored as part of the workbook or be setup through VB when the workbook
is opened, so that the toolbar will show for that workbook when opened on
any machine. I would prefer the toolbar option to menu options as the
toolbar gives a nice intuitive means of operating for the end user.

--
Regards,

David Coates

Progen Ltd.
Mobile : 021 685 607
Phone : +64 7 839 3326
Fax : +64 7 839 3327

CONFIDENTIALITY : This e-mail and any attachments are confidential and
may be privileged. If you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.

 

[Vasant Nanavati]

You should create the toolbar using VB when the workbook is opened and
delete it when it is closed. Plenty of examples here:

http://google.com/groups?as_q=create delete toolbar&as_ugroup=*excel*

 

[David C]

Thanks a heap. It helped a lot and I now have a custom toolbar (sorry
commandbar) with custom buttons and their own macros assigned to them.

And they open and close with the workbook.

Once again thank you

 

[Vasant Nanavati]

Glad it helped!

--

Vasant

Thanks a heap. It helped a lot and I now have a custom toolbar (sorry
commandbar) with custom buttons and their own macros assigned to them.

And they open and close with the workbook.

Once again thank you