Macros for formatting, navigating, and managing tax workpapers. Auto table of contents and more.
Strips the Read-Only Recommended flag and Marked as Final flag from any workbook so you stop seeing the prompt every time you open the file. Two properties, one click, never again.
Scans every sheet for VeryHidden tabs that don't appear in the Unhide dialog, lists what it found, and reveals them all with one click. No data is lost — it was always there, just invisible.
Before sending a tax model to a client, lock every formula cell and unlock every input cell across all sheets. One InputBox for the password, one click to protect the entire workbook. The recipient can change inputs but can't touch your logic.
Scans every sheet for dates in mismatched formats — real dates, text dates, ERP exports, bank feeds — and standardizes them all to one format. Report first, then convert.
Finds every cell containing an empty string (the formula result of "") and replaces it with a truly blank cell. Fixes broken pivot tables, restores ISBLANK(), and shrinks the used range — across every visible sheet in one pass.
One click removes the invisible leading apostrophe from every cell in your workbook, converting text-formatted numbers and dates into their actual types. The silent killer of SUMIF, PivotTables, and sorts.
One click trims every invisible space in your workbook — leading, trailing, and internal double-spaces. The silent killer of VLOOKUPs, SUMIFs, and pivot table groupings, fixed in under two seconds.
Sort every visible sheet alphabetically with one click, or define a custom order from a lookup sheet. Stop hunting for tabs.
One InputBox, one number, and every column on every sheet gets the same width. Or enter 0 and every column auto-fits to its content. Stop adjusting columns one sheet at a time.
Scans every data connection in the workbook and tells you which ones are orphaned. Removes dead connections with one click while leaving active query links intact.
Scans every sheet for cell comments, lists them with counts per sheet, and deletes them all with one confirmation click. The companion to Comment Collector — save notes first, then strip them before sending.
Scans every sheet for floating shapes — text boxes, arrows, rectangles, callouts — lists them by sheet and count, then deletes them all with one confirmation click. Clean up inherited workbooks in seconds.
One click removes freeze panes from every sheet in the workbook. Lists which sheets were affected so you know what changed. The fastest way to un-break an inherited file's scroll positions.
Scans every sheet for conditional formatting rules, lists them with a per-sheet breakdown, and removes them all on confirmation. Fix slow, chaotic workbooks inherited from prior preparers.
Scans every sheet for merged cells, shows you exactly where they are, and unmerges them all with one confirmation click. Values stay in the top-left cell — nothing is lost.
Select a template range with dropdowns and input restrictions, then copy those rules to the same cells on other sheets — all in one pass.
Scans every sheet for leftover print areas, lists which sheets are affected, and clears them all with one confirmation click. No more hitting Ctrl+P and seeing only rows 1-47 from the prior preparer.
Resets the last-cell cursor position on every sheet so Ctrl+End lands on the actual last cell with data, not row 65,536. Fixes scrolling, printing, and file size.
One click unhides every hidden row and column across all sheets. The row/column equivalent of Unhide All Sheets — zero configuration, instant results.
Finds every user-created cell style in your workbook — the kind that's been copied from 12 preparers over 7 years — lists them all in one report, then deletes them with a single confirmation click.
Scans every sheet for data validation rules, lists which sheets are affected, then removes them all with one confirmation click. No more wondering why you can't type in a cell.
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.
Scans every sheet for hyperlinks, lists what it found and where, then removes them all with one confirmation click. No more sending internal file paths to clients.
Colors every sheet tab by category using a lookup table you edit — not the VBA. Keyword matching auto-assigns green to trial balances, blue to schedules, orange to fixed assets. One click, 30 color-coded tabs.
Lists every named range — workbook-level and sheet-level — on a single report sheet with scope, visibility, refers-to formula, and current value. The companion to Delete Broken Named Ranges: understand what's there before you clean it up.
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.
Scans every cell comment on every sheet and compiles them into a single report with hyperlinks back to each source cell. One click replaces 20 minutes of clicking through 30 tabs.
Scans every formula across every sheet and builds a report of every workbook this file links to — which sheets reference each file, how many formulas per sheet, and whether the link is live or broken. Non-destructive. No confirmation dialog.
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.
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.