Fix Excel Macro Buttons Disappearing on Mac
Question details
The user needs Excel macro buttons to remain visible on a Mac without having to right-click.

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

Reset Excel preference files
Try resetting Excel preferences if the buttons still disappear after updates.
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.

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.




