Can you share a personal macro workbook

[Lynneth]

Can you share a personal macro workbook?

I have created a macro on one PC, but want to be able use it on two other networked computers. Is it possible to copy the macro onto other computers, or do I have to recreate the same macro on each computer

Thank you

[Bob Phillips]

In Tools>Options>general there is a startup file location. You could put the
file in a network directory and add that there. But it does leave you
vulnerable to network failures.

If you just need to share macros, what about an addin?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Lynneth" <[email protected]> wrote in
message news:[email protected]...
>
> Can you share a personal macro workbook?
>
> I have created a macro on one PC, but want to be able use it on two
> other networked computers. Is it possible to copy the macro onto other
> computers, or do I have to recreate the same macro on each computer
>
> Thank you
>
>
> --
> Lynneth
> ------------------------------------------------------------------------
> Lynneth's Profile:
http://www.excelforum.com/member.php...o&userid=26102
> View this thread: http://www.excelforum.com/showthread...hreadid=498276
>

[JNW]

You should be able to copy that macro in the personal.xls on the first
computer to the personal.xls on the other computers.

"Lynneth" wrote:

>
> Can you share a personal macro workbook?
>
> I have created a macro on one PC, but want to be able use it on two
> other networked computers. Is it possible to copy the macro onto other
> computers, or do I have to recreate the same macro on each computer
>
> Thank you
>
>
> --
> Lynneth
> ------------------------------------------------------------------------
> Lynneth's Profile: http://www.excelforum.com/member.php...o&userid=26102
> View this thread: http://www.excelforum.com/showthread...hreadid=498276
>
>