VBA & Macro Problems

Fix Excel Macro Buttons Disappearing on Mac

Bushra ParveenBushra Parveen Nov 20, 2026 868 views

Question details

The user needs Excel macro buttons to remain visible on a Mac without having to right-click.

Fix Excel Macro Buttons Disappearing on Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
Working in an Excel workbook that contains macro buttons.
Observed behavior
Macro buttons disappear and become visible after the user right-clicks.
Before you start

Identify how Office was installed so you can use the correct update method. Note any installed Excel add-ins, including reference managers or font-management tools, that may also need updates.

Solution 1Recommended

Update macOS, Office, and Excel add-ins

Use this recommended approach to address outdated system, Office, or add-in components that may affect button display.

1
Update macOS

Open System Settings > General > Software Update and install any available macOS updates. On older macOS versions, check System Preferences > Software Update or the App Store.

2
Update Office

If Office was installed from the Mac App Store, open the App Store and select Updates. Otherwise, open an Office application, select Help > Check for Updates, and install available updates through Microsoft AutoUpdate.

3
Update add-ins

Check the update option or support site for each installed add-in, such as EndNote, Zotero, Webex, or a font-management tool, and install available updates.

4
Restart and test

Choose Apple menu > Restart, then open the workbook in Excel and check whether the macro buttons remain visible without right-clicking.

Update macOS, Office, and Excel add-ins
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 Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not repair Excel's button display issue, and macro compatibility should be checked before relying on an existing workbook.

Open and edit spreadsheet data in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsReview workbook contents while troubleshooting ExcelFree and lightweight for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel macro buttons reappear when I right-click?

The right-click may trigger the worksheet to redraw. Outdated software, add-ins, or corrupted Excel preferences are possible causes, but the behavior alone does not identify the cause.

How do I update Excel if I installed it from the Mac App Store?

Open the App Store on your Mac, select Updates, and install any available Microsoft Office or Excel update.

Where can I find Microsoft AutoUpdate?

Open an Office application and select Help > Check for Updates. Use Microsoft AutoUpdate to install available Office updates.

Will resetting Excel preferences delete my workbook?

Moving com.microsoft.Excel.plist aside does not delete your workbook, but it can reset some Excel settings. Quit Excel first and keep the original preference file so you can restore it if needed.