VBA & Macro Problems

Prevent Excel for Mac AutoOpen Macros When Opening a Workbook

Nimra MalikNimra Malik Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Locate the workbook

In Excel, choose File > Open and locate the workbook, but do not open it yet.

2
Open while holding Shift

Hold down Shift, open the selected workbook, and keep holding Shift until the workbook has finished opening.

3
Check the result

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.

Behavior may vary: This method has been reported to suppress AutoOpen macros, but it is not guaranteed for every Excel version or automatic event. Do not rely on it as a security measure for an untrusted workbook.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with common Microsoft Excel formats, including XLSX and XLSReview spreadsheet data without relying on Excel's AutoOpen behaviorMove between Office documents with a lightweight suite
microsoft office alternative - wps office

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.