Fix Invisible Text Boxes and Macro Buttons in Excel for Mac
Question details
The user needs to make text boxes used as macro buttons visible in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A workbook contains text boxes assigned to macros, and the user wants to see and use them reliably on a Mac.
- Observed behavior
- The text boxes remain functional but become invisible. Resizing a row or column may temporarily make them visible, and the issue may not occur in Windows.
Confirm that the affected text boxes have macros assigned to them and note whether resizing a row or column temporarily restores their appearance. Check the workbook's file format, because saving as .xlsx removes VBA macros.
Copy the affected worksheets into a new workbook
Use a new workbook to test whether the original workbook is contributing to the display problem.
Copying worksheets to a new workbook helped in the reported case, while duplicating the original workbook did not. Workbook-level VBA code and other settings may not transfer automatically.
In Excel for Mac, select File > New to create a blank workbook.
In the original workbook, Control-click the affected sheet tab and choose Move or Copy. Select the new workbook as the destination and check Create a copy.
Open Tools > Macro > Visual Basic Editor and check whether the required workbook-level VBA modules are present in the new workbook. Copy any missing code and review button assignments as needed.
In the new workbook, select File > Save As and choose Excel Macro-Enabled Workbook (.xlsm). Reopen it and test both the visibility and function of each button.

Test a different macro-compatible workbook format
Try another format to check whether saving the workbook differently affects the display issue.
Test the workbook in another Mac account or computer
Compare the behavior in a different Mac environment to help identify whether the issue is specific to an account or computer.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface and support for common Office formats, making it easy to move everyday spreadsheet work between applications. It does not fix Excel for Mac's display issue; check macro compatibility before relying on automated buttons.

Frequently Asked Questions
Why does resizing a row make the text boxes visible again?
Resizing may temporarily refresh the worksheet display, but it does not identify or permanently fix the cause. Try copying the affected sheet into a new workbook and reopening it.
Will saving the workbook as .xlsx keep my macros?
No. The .xlsx format does not retain VBA macros. Use File > Save As and choose .xlsm or .xlsb when the workbook needs macros.
Does copying a sheet also copy every macro?
Not necessarily. Check Tools > Macro > Visual Basic Editor in the new workbook for required workbook-level code, and test the button assignments after copying.
What does it mean if the workbook works in another Mac user account?
It suggests that the issue may be related to the original account's environment rather than the workbook alone. Compare the behavior in both accounts and, if possible, on another Mac.
Can changing to .xlsb permanently fix invisible buttons?
It may help in some cases, but it is not a guaranteed fix. In the reported case, the problem returned after an initial improvement, so reopen and retest the converted file.




