Premium Membership

Save 15% on Pro Premium Plan with discount code: UX778 (expires on October 31st). Study specialized LV/MV/HV technical articles and papers.

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! Please keep in mind that comments are moderated and rel="nofollow" is in use. So, please do not use a spammy keyword or a domain as your name, or it will be deleted. Let's have a professional and meaningful conversation instead. Thanks for dropping by!

  ×  eight  =  64

Learn to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Apply a 15% discount code EAB77 and enjoy learning!

Subscribe to Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and electrical guides.