Activate the Open section - if you're not on that page already.Start with opening Excel (only Excel, not the workbook).This method doesn’t work when you open a file directly from your desktop or from the Windows Explorer. Beware that you should be in Excel’s Open window to make this work. If you hold down the Shift key when opening the file, the macros will not run. We’ll start with an easy approach to disable Workbook_Open and Auto_Open. You can use the following two approaches if you need to open a workbook manually. Let’s now take a closer look into how to disable Workbook_Open and Auto_Open: Opening a workbook manually Excel triggers Workbook_Open before Auto_Open.Workbook_Open should be in ThisWorkbook Auto_Open can be in any module.If you wonder the difference between Workbook_Open and Auto_Open, here is a summary:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |