Excel Macro Guy
Copy-paste-ready Excel macros for tax workpapers. Built and tested with a real accountant — every macro has been run on actual client workpapers.
Standardizes print settings — landscape, fit-to-width, narrow margins, centered — across every qualifying sheet in one pass. No more setting up Page Setup 30 times before the partner review.
One password, one click, every visible sheet locked or unlocked. Lock workpapers for filing, then unlock them for batch edits — without right-clicking 30 tabs and retyping the same password each time.
Scans every sheet in a workbook and builds a complete inventory — visibility, row count, column count, formula status, protection, and more. The first macro you run when someone hands you their file.
Welcome to the Tax Automation Blog. Copy-paste VBA macros built for tax preparers, not developers. No programming required — just real macros for real workpapers.
Scans every sheet in a workbook, finds every formula error cell, and builds a clickable report with hyperlinks back to each one. Zero input — open a broken workbook, run the macro, and triage every error in seconds.
Scans every named range in your workbook, identifies which ones are broken (#REF!), lists them with visibility info, and deletes them all with one confirmation click. No more deleting them one at a time in Name Manager.
Scans a workpaper for hard-coded numbers hiding in columns where every other cell is a formula. Flags only the suspicious ones — not every constant on the sheet — and writes a reviewable report to a new tab without touching the original data.
Paste your prior-year and current-year trial balances into two sheets, run the macro, and get a side-by-side comparison with dollar and percentage variances. Accounts that opened, closed, or moved more than your materiality threshold are all flagged in one pass.
One macro that sets the period-end date on the first sheet and links every other sheet to it with a formula. Change one cell, update forty tabs.
Strips leading and trailing spaces from every sheet name, then optionally sorts tabs alphabetically. Handles name collisions gracefully so you don't break the workbook.
One macro finds every cell linking to another workbook — live or broken — and replaces it with the current value. Send clean workpapers without the 'This workbook contains links' warning.
Scans every sheet in a workbook, builds a hyperlinked table of contents on a new index sheet, and auto-updates when tabs are added, renamed, or deleted. The 30-tab workbook just became navigable.
A tongue-in-cheek macro that keeps your status green while you step away from your desk. Teams won't know. Slack won't know. Your conscience might.
Three InputBoxes — firm name, client name, tax year — and every qualifying sheet gets standardized headers and footers for print. Twelve sheets updated in under a second.
Two InputBoxes, one confirm, and every sheet in the workbook is updated. Counts replacements per sheet so you know exactly what changed.
Unhide every hidden sheet in a workbook with one click. Ten lines of VBA, zero configuration, and the fastest win you'll ever get from a macro.
No posts found