How to ditribute a macro?

V

voltage

OK I have created a macro and it's nested in "personal.xls" . I would
like to share it with other friends in my company, but I don't know
how.

How do I extract the macro along with the tool bar or button and send
it to a friend? Once received, how does the recipient install it?

As much detail as possible is welcome!

Thank you so much for any assistance provided. :)
 
R

Rowan Drummond

Create a new workbook. Move/copy the macro to this workbook. Add
routines to that workbook's workbook_open and workbook_close events to
create and remove a menu item with which to access the macro (maybe like
this http://j-walk.com/ss/excel/tips/tip53.htm).

Goto file>properties. Click on the Summary tab and enter a short
discription of what the macro does in the Comments field. Now save the
new workbook as a Microsoft Excel Add-In (last option in Save as Type
drop down in Save As dialog). This will save the file in your Microsoft
addins folder. On my system this is C:\Documents and
Settings\username\Application Data\Microsoft\AddIns.

Save a copy of the file on a network or email it to the user. Have them
save this file in their add-ins folder. When they open excel they can
then install your add-in via the Tools>Add-Ins menu option.

Regards
Rowan
 
Top