distributing a macro
 

H, I've written a macro in Excel 97 that I would like to
share with my team, who is not technical. How can I
simplify the install of the macro into their
personal.xls? I created an Add-in but I don't know how to
point it to personal.xls.

Rich

distributing a macro
 

An addin doesn't have a relation to personal.xls. You would place the addin
file on there machines or in a common drive, then then in Tools=Addins,
you would use the browse button to find it and select it.

This will load the addin and your function should be available for use.

A UDF (function) will be available to the worksheet

A "SUB" will not be visible in Tools=Macro=Macros. It would be best to
add a menu button in the tools menu or on the main menu that would call the
macro.

Here is another article or two you might find useful:
http://msdn.microsoft.com/library/ba...n_addins97.htm
http://msdn.microsoft.com/library/of...exceladdin.htm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications

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




--
Regards,
Tom Ogilvy

"Rich Clarken" wrote in message
...
H, I've written a macro in Excel 97 that I would like to
share with my team, who is not technical. How can I
simplify the install of the macro into their
personal.xls? I created an Add-in but I don't know how to
point it to personal.xls.

Rich