Ad Clicks :Ad Views :
    Excel formulas and tutorials

    Excel formulas and useful tools

    img

    Run macro on open file event

    /
    /
    /
    478 Views

    In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer.

    You must first open the VBA editor in Excel and type your macro code inside the Sub Workbook_Open().

    I attach a picture for you to see what I am trying to explain above:

    run macro on open file

    In this way, when the file open event happens, the macro code inside Workbook_Open sub will run.

    Don’t forget to save the file as .xlsm or the older format .xls, as .xlsx doesn’t save the code behinf the excel file.

    Enjoy Excel VBA Macros!

    • Facebook
    • Twitter
    • Google+
    • Linkedin
    • Pinterest

    Leave a Comment

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    This div height required for enabling the sticky sidebar