Free Excel VBA macros and Windows tools I have built and use myself. The VBA modules are .bas files you import into any workbook in a minute; the Windows tools are open source on GitHub.
12 Excel VBA macros that save hours every week
The small macros I use on almost every client file. One .bas file you import once, with clear comments and step by step instructions.
- Unhide, protect and unprotect all sheets
- Delete blank rows and clean messy text
- Highlight duplicates in any range
- Split one sheet into many by a column
- Combine every sheet into one
- Export each sheet to its own PDF
- Clickable sheet index, dated backups and a formula audit list
Single VBA modules
Each module comes with a step by step guide on the blog.
Split Sheet by Column
Turns one long list into a separate sheet for every region, salesperson or customer, with the header row on each sheet.
Outlook Mail Merge
Sends a personalised email from Outlook to every row of your Excel list, with names and details filled in for each person.
Combine CSV Files
Combines every CSV file in a folder into one sheet in a single click.
Master Control Lock
Locks or unlocks every sheet in a workbook with one button.
Free Windows tools (open source)
PDF Master Toolkit
An all in one PDF desktop app with 30+ tools: merge, split, OCR, convert to and from Word and Excel, compress, sign, redact and batch workflows. Everything runs locally.
AutoBrowse
A tray app that keeps chosen websites open and fresh in your own Chrome, on a fixed or random schedule, and alerts you when a page changes, logs you out or goes down.
Bengali to English Vocabulary Trainer
Learn English vocabulary from Bengali with word cards, five practice styles and spaced repetition, using 3,805 built in entries from CEFR A1 to C2.
SeleniumBasic Edge Driver Updater
SeleniumBasic stops working whenever Microsoft Edge updates. This downloads the matching Edge driver and installs it into SeleniumBasic for you.
Need something built around your own data? These free tools are small versions of what I build for clients every week.
Tell me what you need