Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to run macro automatically (excel 97/2000)

    hi
    i have written a macro for a workbook to do something. how can i make these macro code run when i open the workbook automatically without going Tool --> Macro ----> Run

    thanks alot

  2. #2
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to run macro automatically (excel 97/2000)

    Place your code in the workbook_open event in the ThisWorkbook Module. It will run anytime the workbook is opened.

    Not knowing what it is that you want to accomplish, it is hard to give you any suggestions.

  3. #3
    Lounger
    Join Date
    Jul 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to run macro automatically (excel 97/2000)

    hi thanks..i got it already .actually what you suggest is what i'm looking for.
    really thanks alot

Posting Permissions

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