|
In order to use MEI
Estimating Software with Excel 2002, macros must be enabled and access to
the Visual Basic Project granted.
Enabling macros is
accomplished in several ways. You can grant unrestricted access to macros
by setting the Excel Security Level to Low. With this
setting, anytime a spreadsheet is opened that contains macros, they are
automatically enabled. This setting is generally not recommended
because
provides the user with no warning of potential malicious programming.
Access to macros can also be granted with the Security Level set to
Medium. In this case, the user is alerted to the presence of
macros prior to opening the file and can decide to continue or cancel
opening the file. Note that when the security level is set to High,
macros are not enabled and MEI software would not operate.
When the software is run for the first time, a check
of the security settings is made and the user is alerted to a condition
preventing proper operation of our software. The user can then allow
the settings to be automatically updated to the proper configuration if
desired.
Alternately, the user can manually
configure the security setting
as shown in the following
steps.
Step 1. Open Excel.
Step 2. Navigate to
the Security Dialog Box by selecting Tools/Macros/Security...
Step 3. Select a
Medium or Low Security Level.
 
Step 4. Click on the Trusted Sources
tab.
Step 5. Check the Trust access to Visual
Basic Project box.
Step 6. Click OK and close Excel.
You can now open an MEI Estimation file. If
you selected a Medium Security level, you will see the following
dialog box when opening the file. Select Enable Macros
and the file will proceed to open normally.
 |
