Premium Membership

Learn from experienced power engineers. Study specialized premium technical articles, papers & video courses. Get 15% Off on PRO premium plan, use discount code: UX21M

A Note on Excel Programs Containing Macros

Most of the programs available with HVAC Simplified (ASHRAE, 2006) and from the website contain MS Visual Basic macros to perform the more complex calculations. Since macros from unfamiliar sources may contain viruses, the default MS Excel security level is set at “High”. For Office 2003 and earlier products, the user must set the security level to “Medium” or “Low” for the programs to operate. In some networks, resetting the security levels must be performed by the Network Manger.

To reset the security level for Excel 2003 and earlier versions,

  1. If the program containing the macros is open, close it and exit Excel.
  2. Re-open Excel, click on “Tools” on the main tool bar, select “Macro”, select “Security.”
  3. Reset security level to Medium (recommended) or Low
  4. Exit Excel
  5. Re-open Excel
  6. Run program

For 2007 Office products, the terminology “trust” has replaced “security” and the procedure has been changed (as you might expect). To change the “trust” settings:

  1. Open Excel
  2. Click the Office Button (top left corner of screen)
  3. Click on “Excel Options” button @ the bottom of the pop-up window
  4. Click on “Trust Center”
  5. Click on “Trust Center Settings”
  6. Click on “◘ Enable all macros..”
  7. Open and Run the programs
  8. An option would be to reset the trust setting by repeating steps 1 thru 5 and,
  9. Click on “◘ Disable macros with notification”

Premium Membership

Get access to premium HV/MV/LV technical articles, advanced electrical engineering guides, papers, and much more! It will help you to shape up your technical skills in your everyday life as an electrical engineer.
More Information

Leave a Comment

Tell us what you're thinking... we care about your opinion!

EEP Academy Video Courses

The learning platform for LV/MV/HV electrical engineers. Learn from experienced engineers and sharpen up your knowledge.