lkpeo.blogg.se

In the Trust Center, click Macro Settings.Click Trust Center, and then click Trust Center Settings.However, this method is the slowest approach so you may not want to turn on and off macros all the time.įollow the steps below for disabling macros: Release the Shift Key after the workbook is openedĪn obvious way is to disable all macros using Excel Options.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