• Auto Start Macro (Excel 2002 (xp) SP2)

    Author
    Topic
    #409082

    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?

    Viewing 1 reply thread
    Author
    Replies
    • #869162

      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.

    • #869163

      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.

    Viewing 1 reply thread
    Reply To: Auto Start Macro (Excel 2002 (xp) SP2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: