Tags: computers, created, excel, macro, microsoft, msdn, networked, personal, share, software, twoother, workbook, workbooki

Can you share a personal macro workbook

On Microsoft » Microsoft Excel

3,020 words with 2 Comments; publish: Fri, 06 Jun 2008 14:16:00 GMT; (30676.17, « »)

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.mcse.ms/member.php?action...o&userid=26102

View this thread: http://www.mcse.ms/showthread.php?threadid=498276

All Comments

Leave a comment...

  • 2 Comments
    • 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" <Lynneth.2160vb_1136470804.9119.excel.todaysummary.com.excelforum-nospam.com> wrote in

      message news:Lynneth.2160vb_1136470804.9119.excel.todaysummary.com.excelforum-nospam.com...

      > 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.mcse.ms/member.php?action...o&userid=26102

      > View this thread: http://www.mcse.ms/showthread.php?threadid=498276

      >

      #1; Fri, 06 Jun 2008 14:17:00 GMT
    • 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.mcse.ms/member.php?action...o&userid=26102

      > View this thread: http://www.mcse.ms/showthread.php?threadid=498276

      >

      #2; Fri, 06 Jun 2008 14:18:00 GMT