Office for Mac Issues

Fix Invisible Text Boxes and Macro Buttons in Excel for Mac

Steven ParkerSteven Parker Nov 20, 2026 869 views

Question details

The user needs to make text boxes used as macro buttons visible in Excel for Mac.

Fix Invisible Text Boxes and Macro Buttons 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a new workbook

In Excel for Mac, select File > New to create a blank workbook.

2
Copy an affected sheet

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.

3
Transfer required macros

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.

4
Save and test

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.

Copy the affected worksheets into a new workbook
Check the whole workbook: Repeat the copy for other required sheets and verify formulas, links, formatting, and macros. Recreate affected elements if the copied workbook still has problems.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel .xlsx files for easier migrationReview spreadsheet content and objects as an alternative to ExcelFree and lightweight for everyday Office work
microsoft office alternative - wps office

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.