Can you share a personal macro workbook
 

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

Can you share a personal macro workbook
 

In ToolsOptionsgeneral 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" wrote in
message ...

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

Can you share a personal macro workbook
 

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