Forum Discussion
macro not avaliable in this workbook
1: Check whether Excel has blocked the macros
- Close the workbook.
- Open File Explorer and locate the .xlsm file.
- Right-click the file and select Properties.
- On the General tab, look at the bottom for a Security message with an Unblock checkbox.
- If it appears and you trust the file, check Unblock, click Apply, then OK.
- Reopen the workbook.
2: Enable macros in Excel
- Open Excel.
- Go to File → Options → Trust Center.
- Click Trust Center Settings → Macro Settings.
- Choose an appropriate setting that allows the workbook's macros to run, subject to your organization's security policies. Avoid enabling all macros globally.
- Click OK and reopen the workbook.
1 Reply
Those two steps are the usual fix, so the next clue is which bar Excel shows when the file opens.
If the red SECURITY RISK bar is still there, the Mark of the Web hasn't come off. That happens when the file sits on a network share (Microsoft notes the Unblock box can be missing or have no effect there), or when Unblock was ticked on another copy. The (5) in the name suggests there are several downloads, so check it's the same file you open. Close Excel, copy the file to a local folder such as Documents, right-click it > Properties > tick Unblock > OK, and open that copy. Or add the folder as a trusted location: File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location.
If the yellow SECURITY WARNING bar shows instead, click Enable Content and try the button again.
If there's no bar at all and you still get the error, press Alt+F11 and look under Modules for a macro called AddEditEmployerIncome. If it isn't there, this copy doesn't contain the macro and a fresh download from the source is the fix. On a work PC, an IT policy can also block macros in files from the internet whatever you set in the Trust Center, and then your IT team has to allow it.
(Drafted with AI assistance and checked before posting.)
