ExcelGurus tools rely on macros (Excel’s built-in automation) to do their work. If macros are turned off, the buttons inside the tool won’t respond. Turning them on takes less than a minute — the exact steps depend on the message Excel shows you when you open the file.
First: click “Enable Editing”
When you open a file you downloaded, Excel often shows a yellow Protected View bar first. Click Enable Editing to start working with the file. After that, you’ll see one of the macro messages further down this page.
Not sure which message you’re seeing? Pick the one that matches:
Red banner: “Microsoft has blocked macros from running”
If you downloaded the file from the internet (including from email or a website), Excel shows a red banner:
There is no “Enable Content” button on this banner — that’s by design, and it’s why this one trips people up. Windows has tagged the downloaded file as coming from the internet, and you need to clear that tag on the file itself before opening it:
Close the file in Excel if it’s open.
Open File Explorer and find the downloaded file (check your Downloads folder).
Right-click the file and choose Properties.
On the General tab, look at the very bottom. If you see a security notice with an Unblock checkbox, tick it.
Click OK.
Reopen the file. The red banner is gone. If a yellow bar appears instead, click Enable Content (see the next section).
Right-click the file → Properties → tick Unblock → OK.
Tip: Moving the file into a folder you’ve set as a Trusted Location (see the Trust Center section below) avoids this step for files you use regularly.
Yellow bar: “Enable Content”
If Excel shows a yellow bar across the top reading “SECURITY WARNING — Macros have been disabled,” this is the simple case:
Click the Enable Content button on the yellow bar.
That’s it — the tool’s buttons will now work.
Excel remembers your choice for this file, so you typically only have to do this once per file.
No message, or managing your macro settings (Trust Center)
If you open the tool and the buttons simply don’t respond — with no yellow bar and no red banner — your macro settings may be turned all the way off. Check them in Excel’s Trust Center. In Excel, go to File → Options, then follow the four numbered steps below.
Steps 1–2: select Trust Center, then click Trust Center Settings.Steps 3–4: open Macro Settings, then choose “Disable VBA macros with notification.”
In Excel, go to File → Options.
Choose Trust Center (bottom of the left list), then Trust Center Settings…
Select Macro Settings.
Choose “Disable VBA macros with notification” — the recommended, safe setting. It keeps macros off by default but lets you enable them per file via the yellow bar.
Click OK, then close and reopen the file.
Please don’t choose “Enable all macros.” It turns off Excel’s protection for every file you ever open, not just ours — a real security risk. The “with notification” setting is the right balance.
For a tool you use often: a cleaner option than changing global settings is to add a Trusted Location. In the same Trust Center screen, choose Trusted Locations → Add new location and point it at the folder where you keep the tool. Files opened from that folder run without any prompt, while every other file stays protected.
Still stuck after trying these steps? Contact support and we’ll help you get up and running.
