Installing and enabling Damper Analysis macros

PROBLEM

After installing Microsoft Excel, how do you connect Excel to the damper software to view the data?
Why when trying to create a new workbook does the Damper Analysis lock out and do you have to close the Damper Analysis application?
How do you enable macros to work in Excel?

 

ANSWER

When the damper applications from CD are installed, it installs a macro called Damper Analysis.  Once Excel is installed and the macros are enabled you should be able to run the Damper Analysis and it will open Excel to the macro.  

 
Enabling Macros in Excel 2003

 
Navigate to ‘Tools’ tab > ‘Macro’ > ‘Security’ (Figure 1).

 

Figure 1

 
After clicking on the ‘Security’ option, a Security window will open. It will show you all the security levels that you can select.  

 
Choose ‘Low Security’ and click on OK.

 
Enable Macros in Excel 2007

 
With an excel file opened click on the ‘Office’ button.
 
Then click on ‘Excel Options’ (present at the bottom).
 
Next select the ‘Trust Center’ > ‘Trust Center Settings’.
 
In the trust center settings click on the ‘Macro Settings’. Choose Enable all macros (not recommended, potentially dangerous code can run) (Figure 2).

 

Figure 2
 


 
Enabling Macros in Excel 2010 and 2013

 
Open a Microsoft Excel file, and navigate to ‘File’ > ‘Options’ > ‘Trust Center’.  Click ‘Trust Center Settings’ (Figure 3).

 

Open a Microsoft Excel file, and navigate to ‘File’ > ‘Options’ > ‘Trust Center’.  Click ‘Trust Center Settings’ (Figure 3).

 


Figure 3

 

In the Trust Center Settings window select the ‘Macro Settings’ option.   Choose the security setting Enable all macros.

 

Once the Excel Macros have been enabled close the Damper Analysis program and then restart it.  The macros should run just fine from then on.

 

 

 

K
Keary is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.