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
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