Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: copying macros

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I just got a new machine and want to copy all of my Excel macros (and custom buttons if possible) from my old box to the new machine. Is there an easier way to do this without re-recording the macros and recreating all of the custom buttons?

    Any help would be greatly appreciated!!!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can't you just copy the file across

    otherwise you can export the modules from the project explorer.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The odd thing is that if I do a search for any of the macros (in explorer), there are no returned results. All of the macros are stored in the "personal" macro workbook in excel, and I can copy the personal.xls file over, but in order for me to access the macros, I have to start Excecl by opening the personal.xls file first!

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, I was able to copy the Macros over, but what about the custom buttons?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •