Sharing macros - extreme newbie question I know.

[rfalke]

I have written several macros in excel that present a form to the use
then connects to a database to bring in information directly to th
spreadsheet. My question is: How do I install (I guess that is th
correct word) these macros on others machines so they can use thes
macros? Are Add-Ins the answer? I have created an Add-In but no
what? Your replies are greatly appreciated. Thanks

--rya

 

[Tom Ogilvy]

Put the addin in a central location. then the user can do Tools=>Addins and
nagivate the addin and select it.

However, you need to have your addin create a toolbar or menu to run the
macros, because the macros in the addin will not be visible in
Tools=>Macro=>Macros.