Guideline to Download and Use Excel VBA Templates

Before start using the VBA templates downloaded from internet, you have to follow some guidelines. This is because Macro or VBA enabled Excel file downloads in blocked mode due to security reason.

For safety, always check the trustworthiness of the source, from which you are downloading the Macro/VBA enabled excel files.

---

Before you start Using Excel VBA Templates, Follow these Steps.

1. Download the File.
2. If file is inside compressed zipped folder, first, unzip it. (to unzip, right click on folder, then click on extract all or unzip)
3. Right click on the extracted Excel file, then click on properties.
4. In the file properties window, mark the unblock checkbox, then click on Apply and Ok.
5. Open the file.
6. At the first open, file will be opened in protected view. Click on enable editing button.

After completing all these 6 steps, you are ready to use the Macro/VBA enabled excel file.

Please see below images for more clarity on the process.

---

Steps 1 to 3

Steps 4 to 6