Office of Budget Management Budget Revision Form Macro Issues
Introduction: The budget revision form contains two macros. These macros are essential to completing the form correctly. Unfortunately, the settings on your computer may not allow the macros to work correctly (i.e. you cannot complete the “Department” or “Contact/Ext” boxes, etc.). To correct these issues do the following in Excel prior to enabling macros: Go to Tools Select Macro Select Security Select Security level Medium Enter Okay
We highly recommend saving the budget revision form onto your hard drive. If you do not save the form; you will also need to complete the following steps on your internet page: Go to Tools Select Internet Options Select Security Select Custom Level Reset to Medium (drop down arrow) – click reset, select okay Click Apply Click Okay
The macros are not e-mail friendly. Should you need to share a copy of a budget revision form via e-mail; the options below will provide some alternatives for doing so. Option 1: Print Screen Open the budget revision form and complete as needed. Save an electronic copy to your hard drive or network drive. Open the form on your computer screen then hold down the “Ctrl” key and “Print Screen” key at the same time. This will make a screen shot of the image on your computer screen which you can then paste into a word document. Save the word document to your computer hard drive or network drive, and attach it to your e-mail. Option 2: Save the form to a shared network drive If you wish to share the budget revision form electronically and you have a shared network drive with the individual you intend to share it with, save the form to this shared network drive. Option 3: Convert file to .pdf format (Office 2007 users only) Office 2007 includes a .pdf file conversion feature by selecting the .pdf format under the “File” “Save As” menu/ribbon. After saving the file as a .pdf you can attach it to e-mail.