Can you share a personal macro workbook

Explore Related Content On "Microsoft Excel"

• Hot Articles & Questions on "Microsoft Excel"
• Can you share a personal macro workbook
• Can you set up Excel to automatically add a standard footer?
• Can you set up a simple address book in Excel
• Can you set up a "Return" key - like a typewriter?
• Can you set up a "Return" key - like a typewriter?
• Can you set the max number of rows for a spreadsheet?
• can you set the "Page Setup" margins etc. differently for each pag
• Can you set Individual Cell Widths ?
• Can you set Individual Cell Widths ?
• CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL

• Open Articles & Questions on "Microsoft Excel"
• Can you set up custom menus in Excel 2007?
• Can you set up custom menus in Excel 2007?
• Can you set permanent header/footer settings?
• Can you set order in Pivot Table Drop Down box?
• Can you set certain cells as read only?
• Can you set a default to always include a footer containing the pa
• Can you set a "trigger" in excel to send an email?
• can you select rows in excel with a certain background color?
• Can you search for patterns?
• Can you search for common results in many wrksheets?

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.itags.org.excelforum-nospam.com> wrote in

    message news:Lynneth.2160vb_1136470804.9119.excel.itags.org.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