attaching toolbar to add-inn without using code?

Is there anyway of attaching a toolbar to an .xla without
using code?

I am not a programmer.



Subject: Can I attach a toolbar to an add-in?
From: "Tom Ogilvy" Sent: 8/17/2004
8:18:24 AM



instead of attaching your toolbar, create it with code in
your xla. At that
time you can assign your macros and they will point to the
xla.

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

I guess as an alternative, you could attach your toolbar
and then have you
code go through and assign the correct macro to the
onaction property of
each control. This would be done in the open event of the
XLA so it occurs
when the XLA is loaded.

--
Regards,
Tom Ogilvy

"JB" wrote in message
...
I need to deploy my .xla file to all in my department.

I have created macros and a toolbar with buttons pointing
to the macros... and saved as "my macros.xls".

When I save the file as "my macros.xla", the toolbar
which
was attached remains attached to the "my macros.xls"...
thus the .xla IS NOT SELF-CONTAINED.

It does not appear that I can open the .xla file in order
to attach the toolbar.

Thoughts?

Thanks for your help!

JB

If you turn your addin back into a .xls, you can attach a toolbar to the
workbook.

Then save it as an addin.

But if you're going to do this, read these notes by Jan Karel Pieterse:
http://google.com/groups?threadm=083...0a% 40phx.gbl



JB wrote:

Is there anyway of attaching a toolbar to an .xla without
using code?

I am not a programmer.

Subject: Can I attach a toolbar to an add-in?
From: "Tom Ogilvy" Sent: 8/17/2004
8:18:24 AM

instead of attaching your toolbar, create it with code in
your xla. At that
time you can assign your macros and they will point to the
xla.

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm

I guess as an alternative, you could attach your toolbar
and then have you
code go through and assign the correct macro to the
onaction property of
each control. This would be done in the open event of the
XLA so it occurs
when the XLA is loaded.

--
Regards,
Tom Ogilvy

"JB" wrote in message
...
I need to deploy my .xla file to all in my department.

I have created macros and a toolbar with buttons pointing
to the macros... and saved as "my macros.xls".

When I save the file as "my macros.xla", the toolbar
which
was attached remains attached to the "my macros.xls"...
thus the .xla IS NOT SELF-CONTAINED.

It does not appear that I can open the .xla file in order
to attach the toolbar.

Thoughts?

Thanks for your help!

JB

--

Dave Peterson