If a QuickText button reports that a macro is unavailable, or Excel says macros are blocked, start with the downloaded workbook. Only enable macros in a QuickText file you obtained from your official download link and trust.
Video tutorial #
The video shows where to find the controls. Follow the written steps below for the current macro-security guidance.
Written steps #
1. Unblock your QuickText workbook
- Close the workbook in Excel. If it is still inside a ZIP file, extract it first.
- In File Explorer, right-click QuickText.xlsm and choose Properties.
- On the General tab, look for Security near the bottom. If Unblock is shown, select it, click Apply, then OK.
- Open the workbook again in desktop Excel.
No Unblock checkbox? Continue below. Its absence does not confirm that macros are allowed; Excel settings or your organization’s policy can still block them.
2. Check the message in Excel
- Yellow Security Warning: click Enable Content for your trusted QuickText workbook.
- Red Security Risk: Excel has blocked macros from an untrusted source. Close the workbook and check the file’s Unblock setting above. This banner does not offer the same Enable Content button.
Try the QuickText button again after reopening the file.
3. If macros are still blocked
In Excel, open File → Options → Trust Center → Trust Center Settings → Macro Settings. On a personal computer, Disable VBA macros with notification lets Excel ask before running eligible macros. It does not override the internet-file block.
Do not select Enable VBA macros for every workbook just to fix QuickText. On a work computer, ask your IT team if a setting is locked or the block remains. See Microsoft’s guidance on downloaded macros.
If macros are allowed but one button still reports a missing macro, download a fresh copy of QuickText and test it before transferring your data. If it still fails, send me the exact error and your Excel version.