If you are working on a very critical project (like an audit), and you would like to keep a record of things every time when you save your Excel file. Despite Excel doesn’t provide the feature – save a backup when saving -, we however, can create the feature on our own. Thanks to VBA, this is much easier than you would think.

In this tutorial, I will show you how to create an auto backup feature using VBA every time when you save your Excel file.

VBA Script