Project Status Reporter
Why am I getting an error message that says "Macros are disabled..."?
The security setting on macros is too high. To change the security level, go into your MS Project schedule and select Tools, Macro, Security. Check mark a lower level of security. If you need to maintain a high security level, you will need to restore it after running the macro. Note that, with a high setting, you will have to make the change before each macro execution.
When I open the Macro, Macros window and select the Analyzer, the Run button is grayed out. Why can't I run the macro?
Again, the security setting on macros is too high. See the answer to the previous question.
Why do I get a run-time error when I attempt to execute the macro?
This problem generally occurs because an Excel library is missing. To correct the problem, go into your MS Project schedule and select Tools, Macro, Visual Basic Editor. In the Visual Basic Editor, select Tools, References. Scroll down. The first entries are already check marked. Subsequent, unchecked entries are in alphabetical order. Find an entry for Microsoft Excel xx.0 Object Library, where "xx" is "10" or "11" or higher. Check mark the highest number. Say OK. Exit the Visual Basic Editor.
How do I install the macro in my MS Project schedule?
It is not necessary to install the plug in. When you are ready to analyze the schedule, simply open the .mpp file provided, go back into your schedule, and run the SchPerfAna macro. Detailed, step-by-step instructions are included in the .mpp file and in the Documentation section of the Web Site.