Creating ustom toolbar
 

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.

Creating ustom toolbar
 

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

http://google.com/groups?as_q=create...roup=*e xcel*

--

Vasant

"David C" wrote in message
...
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.

Creating ustom toolbar
 

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" <vasantn *AT* aol *DOT* com wrote in message
...
You should create the toolbar using VB when the workbook is opened and
delete it when it is closed. Plenty of examples he

http://google.com/groups?as_q=create...roup=*e xcel*

--

Vasant

"David C" wrote in message
...
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.

Creating ustom toolbar
 

Glad it helped! :-)

--

Vasant

"David C" wrote in message
...
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" <vasantn *AT* aol *DOT* com wrote in message
...
You should create the toolbar using VB when the workbook is opened and
delete it when it is closed. Plenty of examples he


http://google.com/groups?as_q=create...roup=*e xcel*

--

Vasant

"David C" wrote in message
...
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.