Prevent Excel for Mac AutoOpen Macros When Opening a Workbook
Question details
The user wants to prevent automatic macros from running temporarily when opening an Excel workbook.
- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- Mac
- Scenario
- Open a workbook without running its AutoOpen or AutoRun macro, while retaining the usual macro settings for other occasions.
- Observed behavior
- The desired result is a one-time way to open the workbook without automatically executing its macro.
Open Excel and check Excel > About Excel for your version. The Shift-key method has been reported to work in Excel for Mac, but behavior may vary by version.
Hold Shift while opening the Excel workbook
Use this one-time method to try to suppress an AutoOpen macro without changing your usual macro settings.
In Excel, choose File > Open and locate the workbook, but do not open it yet.
Hold down Shift, open the selected workbook, and keep holding Shift until the workbook has finished opening.
Verify that the expected automatic macro action did not occur. If the macro still runs, check Excel > About Excel and update Office before trying again.
Temporarily disable macros in Excel security settings
Use macro security settings if you need a more controlled way to open a workbook without running its macros.
Work with Excel files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Excel formats, making it easier to move between applications. It does not change Excel for Mac's macro-opening behavior.

Frequently Asked Questions
Can I stop an AutoOpen macro just once without changing my settings?
Try holding Shift while opening the workbook and keep it held until the file finishes loading. The result may vary by Excel version and macro type.
Where can I check my Excel for Mac version?
In Excel, select Excel > About Excel to see the installed version.
What should I do if holding Shift does not stop the macro?
Check your Excel version and Office updates. You can also disable macros temporarily under Excel > Preferences > Security & Privacy before opening the workbook.
Does holding Shift open Excel in Safe Mode?
No. Holding Shift while opening a workbook is a method for trying to suppress automatic macros; it is not the same as starting Excel in Safe Mode.
Will WPS Office run all macros in my Excel workbook?
Not necessarily. VBA and macro support can vary by WPS version and available features. Check compatibility before relying on a macro-enabled workbook.




