• Preventing auto_open and Workbook_Open events

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Preventing auto_open and Workbook_Open events

    Author
    Topic
    #464557

    Hi everyone,

    This thread set me thinking about how one would prevent workbook_Open events from running and auto_open macros, whilst at the same time being able to run code.

    I discovered the way to do this depends on the Excel version and -especially for Excel 2007 and 2010- isn’t well documented.

    See this article for an elaborate explanation on how to do this.

    Viewing 0 reply threads
    Author
    Replies
    • #1189603

      Thanks! It’s good to have instructions for each version of Excel.

    Viewing 0 reply threads
    Reply To: Preventing auto_open and Workbook_Open events

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

    Your information: