Virginia Department of Education
Budget Office

File Download Instructions

If you are using Internet Explorer as your Internet browser:

1. RIGHT-CLICK on the link for the “Excel Template” you wish to download.
2. Select “Save Target As” and save the file to your local drive.
3. Once the file is saved, close Internet Explorer and open the file using Excel.
4. Please note that in order for the template to operate correctly, you must click on the "ENABLE MACROS" button.
5. If you are prompted with a Microsoft Visual Basic error, please see the instructions below on adjusting macro security levels.

If you are using Mozilla Firefox as your Internet browser:

1. Click on the link for the “Excel Template” you wish to download.
2. After you click on the file name on the Web site, you will be prompted to open the file or save it to a drive. You may choose either option.
3. A box will appear warning you that the file contains macros. The box will prompt you to disable the macros or to enable the macros.
4. Please note that in order for the template to operate correctly, you must click on the "ENABLE MACROS" button.
5. If you are prompted with a Microsoft Visual Basic error, please see the instructions below on adjusting macro security levels.

If you are prompted with a Microsoft Visual Basic error alerting you to disabled macros:

The Excel template that you downloaded to your computer was written using Excel 2003. There are a number of divisions that are using Excel 2007. The procedures for accessing the Excel Template will be explained for both versions below.

For Excel 2003 users, please use the following instructions:

When the Excel template is opened, a box will appear with a warning that the file contains macros. The box will prompt you to disable the macros or to enable the macros. In order for the template to operate correctly, you must click on the "ENABLE MACROS" button.

If you are not prompted with the “Enable Macros” button, or if you are prompted with a Microsoft Visual Basic error alerting you to disabled macros please follow these steps to reset your macro security level:

1. Select the “Tools” menu from the drop-down options at the top of the spreadsheet.
2. Select “Macro;” then select “Security.”
3. Set the security level at “Medium.” This will give you the option to disable or enable macros.
4. You must exit out of the spreadsheet and reopen the file for the macro security changes to take effect.
5. When accessing Excel files from the Department of Education, you must click on the “ENABLE MACROS” button before using the spreadsheets.

For Excel 2007 users, please use the following instructions :

Before opening the Excel template the following set-up needs to be done.

1. Open Excel 2007.
2. Select the “Office Button” in the upper left hand corner of the window.
3. At the bottom of the window, select the “Excel Options” button.
4. On the “Excel Options” window, select the “ Trust Center” from the selections along the left of the page.
5. Then, select the “ Trust Center Settings…” button near the center of the page.
6. On the “ Trust Center” window, select “Macro Settings” along the left of the window.
7. Under the “Macro Settings” section select “Enable all macros”.
8. Select “OK” to close the “ Trust Center” window, then “OK” again to close the “Excel Options” window.

You can now open the Excel template and begin entering your data using Excel 2007.