Excel like a finance pro.
VBA · Getting started
Macro security
Files from the internet are blocked from running macros until unblocked in file properties or trusted.
When to use it
Excel blocks macros in files from the internet or untrusted locations. Users must unblock the file or trust its folder before Workbook_Open or any macro runs.
The code
- Code
File > Options > Trust Center > Macro Settings
Worked examples
Settings
File > Options > Trust Center > Macro Settings → Choose to disable with notification (the sensible default)
Never "enable all".
Unblock a file
Right-click the file in Explorer > Properties > Unblock → Removes the mark of the web so macros can be enabled
For files downloaded or emailed.
Trusted location
Trust Center > Trusted Locations > Add → A folder whose files run macros without prompts
Team folders.
Worth knowing
- Sign macros with a certificate for wider distribution.
- Explain the enable step in a visible sheet that hides on Workbook_Open.
- Do not rely on macros for anything security related.
Where it goes wrong
- Users who cannot unblock will see the workbook without macros.
- Trusted locations on network drives need an extra setting.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.