distributing a macro

[Rich Clarken]

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

 

[Tom Ogilvy]

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/backgrnd/html/msdn_addins97.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingexceladdin.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