How to ditribute a macro?

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.

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

voltage wrote:
> 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.
>
>

I believe this would best be done as an add-in. Check out these sites ...

http://www.j-walk.com/ss/excel/tips/commandbars.htm

http://support.microsoft.com/kb/156942/en-us

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"voltage" <voltage.1yb3ry_1131669000.8516@excelforum-nospam.com> wrote in
message news:voltage.1yb3ry_1131669000.8516@excelforum-nospam.com...
>
> 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.
>
>
> --
> voltage
> ------------------------------------------------------------------------
> voltage's Profile:
> http://www.excelforum.com/member.php...o&userid=28723
> View this thread: http://www.excelforum.com/showthread...hreadid=484156
>

Hi Voltage,

In addition to the other advice, see Jan Karel Pieterse's tutorial and
installation demo at:

http://www.jkp-ads.com/Articles/DistributeMacro00.htm


---
Regards,
Norman



"voltage" <voltage.1yb3ry_1131669000.8516@excelforum-nospam.com> wrote in
message news:voltage.1yb3ry_1131669000.8516@excelforum-nospam.com...
>
> 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.
>
>
> --
> voltage
> ------------------------------------------------------------------------
> voltage's Profile:
> http://www.excelforum.com/member.php...o&userid=28723
> View this thread: http://www.excelforum.com/showthread...hreadid=484156
>