Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running macros (2k)

    With the help of Hans, I have some new macros that I use to format outputed data. When i run the macros in that workbook, all goes well. But when I open a new workbook that needs to be formatted, I can no longer just run the macro because its not from that same work book, I have to paste it into the new work book's VBA editor.

    Is there a way to keep a list of macros that you can always access to run for any work book? or do they have to be copied into new workbooks all the time?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Running macros (2k)

    If it's for yourself only, put the macros in your Personal.xls workbook - its purpose is to be a home for macros that should be available in all workbooks. See Legare Coleman's <!post=Personal.xls Tutorial (All),118382>Personal.xls Tutorial (All)<!/post> for more information.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running macros (2k)

    awesome, thanks!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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