Writing add-ins
http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Neo" wrote in message
oups.com...
Hello All,
I am doing VB programming for a long time and recently moved to VBA for
Word and Excel. Writing macro is very much like reguler Visual Basic
except, distribution is a big problem. As of now, I am just sending
document everyone. But I don't have any nice way to install Macro,
also, no way to hide the source code.
I believe this can be done through add-ins. How can I write add-ins in
VBA? So that I can distribute it with ease and can be used from any
office file. I would like to know tools used for this purpose. I read
something abot Office Developer, but I am still not sure, if it's new
tool or just part of regular Visual Studio. Any information/links would
be very helpful.
Thanks,
Pravin A. Sable