VBA code to copy, move, delete and manage files

Automating processes with VBA can involve copying, moving, deleting and managing lots of files.  Thankfully, VBA has many built-in functions to undertake these tasks for us.  These files do not necessarily need to be Excel workbooks; they can be any file type. Download the example file I recommend you download the example file for this Read More

VBA to protect and unprotect Sheets

Protecting and unprotecting sheets is a common action for an Excel user.  There is nothing worse than when somebody, who doesn’t know what they’re doing, over types essential formulas and cell values.  It’s even worse when that person happens to be ourselves; all it takes is one accidental keypress, and suddenly the entire worksheet is Read More