Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto Start Macro (Excel 2002 (xp) SP2)

    OK, I know I know this, but cannot locate it anywhere...

    What name do you give a procedue that you want to execute automatically everytime you open the file?

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

    Re: Auto Start Macro (Excel 2002 (xp) SP2)

    There are two possibilities:

    1) Create a procedure named Auto_Open in a standard module.

    2) Create a procedure named Workbook_Open in ThisWorkbook. This is an event handler for the On Open event of the Workbook object.

Posting Permissions

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