Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Location
    Itasca, Illinois, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying macros (Excel 2000)

    I have copied macros from one file to another. When I run the macro in the second file it opens the original file. How can I fix this?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Copying macros (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> wmmwall20

    You may have some links, or references still pointing to the old workbook.

    Just as a question, did you select all the text of the macro, and copy and then paste, or how did you accomplish the copying?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Jun 2004
    Location
    Itasca, Illinois, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying macros (Excel 2000)

    I just did a copy from one file and paste the macro to the other file. I did solve the problem. I deleted any links, then for the buttons I had to re-assign all macros. It worked, I just thought there might be a faster solution.

Posting Permissions

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