Greetings,

I am pretty new to this. I have created an add-in for Excel 2003, however I
need to assign a custom button to it. However, the macro doesn't show up in
the "Assign Macro" list when I try to assign it.

If it's just a macro I put in the Excel Directory (C:\Program
Files\Microsoft Office\OFFICE11\XLSTART) the macro shows up... but, that's
not what I need.

Thanks for your help in advance,
mark

Hello Mike,

Add-Ins don't expose their macros by design. Here's another thought.
Maybe your code should be in a VBA project module. You can copy the
module into any workbook you use later on. The macros in the module
will show up in the Assign Macro list.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494225

so, then... what's the advantage of using an add-in? i want this macro to be
used company-wide, sent out to maybe 20 people. if they have to add an
additional file to a directory, it's sort of a bother.

thanks though, you have certainly answered my question. i guess it's just
not possible :-)

thanks,
mark

"Leith Ross" wrote:


Hello Mike,

Add-Ins don't expose their macros by design. Here's another thought.
Maybe your code should be in a VBA project module. You can copy the
module into any workbook you use later on. The macros in the module
will show up in the Assign Macro list.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494225

Addins are great in that they can be distributed as you say. In order to
assign a button you will have to do some work to create a toolbar and then
put your buttons on there. Or you could piggy back on one of the existing
toolbars or the menu bar. In the Thisworkbook module of the addin there is an
addin install and unistall event. When the event is fired you dynamically
create the buttons and/or toolbar and off you go... This is not a project for
the faint of heart but it is very do-able.
--
HTH...

Jim Thomlinson


"mvyvoda" wrote:

so, then... what's the advantage of using an add-in? i want this macro to be
used company-wide, sent out to maybe 20 people. if they have to add an
additional file to a directory, it's sort of a bother.

thanks though, you have certainly answered my question. i guess it's just
not possible :-)

thanks,
mark

"Leith Ross" wrote:


Hello Mike,

Add-Ins don't expose their macros by design. Here's another thought.
Maybe your code should be in a VBA project module. You can copy the
module into any workbook you use later on. The macros in the module
will show up in the Assign Macro list.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494225

so, it is possible to add a custom button to the end users sheet that would
execute the add-in macro? can you point me to a some good reference material
that may achieve this?

thanks so much Jim...,
mark

"Jim Thomlinson" wrote:

Addins are great in that they can be distributed as you say. In order to
assign a button you will have to do some work to create a toolbar and then
put your buttons on there. Or you could piggy back on one of the existing
toolbars or the menu bar. In the Thisworkbook module of the addin there is an
addin install and unistall event. When the event is fired you dynamically
create the buttons and/or toolbar and off you go... This is not a project for
the faint of heart but it is very do-able.
--
HTH...

Jim Thomlinson


"mvyvoda" wrote:

so, then... what's the advantage of using an add-in? i want this macro to be
used company-wide, sent out to maybe 20 people. if they have to add an
additional file to a directory, it's sort of a bother.

thanks though, you have certainly answered my question. i guess it's just
not possible :-)

thanks,
mark

"Leith Ross" wrote:


Hello Mike,

Add-Ins don't expose their macros by design. Here's another thought.
Maybe your code should be in a VBA project module. You can copy the
module into any workbook you use later on. The macros in the module
will show up in the Assign Macro list.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494225