Hi,

I'm a newbie to excel macros. I've been using the excel help file bu
I wasn't able to obtain the information I need on creating an add-in.
I was able to create a macro to load up some data into an excel an
associated this macro to a customized button on the toolbar. I hav
few questions:

1) Currently this macro can only be loaded on my machine and I woul
like to make it available to other users. I was told I can create a
xla file to load up my macro and other users can just intall this xl
file. How do I create an add-in (xla) in the excel so it will load u
my macro?

2) Based on what I need in (1), where should I place my macro? Is i
My Workbook or This Workbook?

3) What do I need to do if I only want this xla fires up under certai
condition?

Thanks!
Cha

--
cha
-----------------------------------------------------------------------
chan's Profile: http://www.excelforum.com/member.php...fo&userid=1641
View this thread: http://www.excelforum.com/showthread.php?threadid=27783