Search

Premium Membership ♕

Limited Time Offer: Save 15% on Pro Plan with discount coupon: MX15. Study specialized LV/MV/HV technical articles and studies.

A Note on Excel Programs Containing Macros

Most of the programs available with HVAC Simplified (ASHRAE, 2006) and from the geokiss.com 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.
50% Discount 💥 - Save 50% on all 90+ video courses with Enterprise Membership plan.

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!

  ×  two  =  fourteen

Learn How to Design Power Systems

Learn to design LV/MV/HV power systems through professional video courses. Lifetime access. Enjoy learning!

Subscribe to Weekly Newsletter

Subscribe to our Weekly Digest newsletter and receive free updates on new technical articles, video courses and guides (PDF).
EEP Academy Courses - A hand crafted cutting-edge electrical engineering knowledge