Lock and unlock every sheet with one Master Control button
October 5, 2026 · 2 min read
Protect a whole workbook with one click while your macros keep working, using the UserInterfaceOnly option most people miss.
Read the postBlog
Excel VBA tips, free files and automation ideas
Short, practical posts with code you can copy and modules you can download and import into your own workbooks.
Combine all CSV files in a folder into one sheet with VBA
September 30, 2026 · 3 min read
Pick a folder and this macro stacks every CSV file into one clean sheet, keeps a single header row and records which file each row came…
Read the postSend personalised emails from Excel with Outlook and VBA
September 25, 2026 · 3 min read
A short mail merge macro that sends one personalised Outlook email per row, with an optional attachment and a status column so nobody gets the same…
Read the post