Excel 2007 Security
Step 1. Open Excel.
Step 2. Open the Excel Options Dialog Box by clicking the Office Button in the upper left
and selecting Excel Options at the bottom of the window.
Step 3. Select the Trust Center option from the left-hand pick-list, then click on
Trust Center Settings...
Step 4. Select Macro Settings from the left-hand pick-list and then select either
Disable all macros with notification or
Enable all macros
Step 5. Also check the Trust access to the VBA project object model box.
Step 6. Click OK and close Excel.
You can now open an MEI Estimation file. If you selected Disable all macros with notification,
you will see the following message displayed once the file is opened.
Click on the Options... button to see the following dialog box.
Select the Enable this content option and click OK. This will activate the
MEI Estimation software. To avoid this message in the future, you can make your Estimation
folder a Trusted Location. Excel will automatically enable macros in files from a trusted location.
To do this, navigate to the Trust center as described in Steps 1 through 3 above. Select
Trusted Locations from the left-hand pick-list and the following screen will appear. Click on
Add new location...
Type in or browse to the estimates folder you selected when installing MEI Estimating software
(default is C:\Estimates). Make sure you check the Subfolders of this location are also trusted box.
Then click OK. Your estimates folder is now a trusted location and you will not have to enable content
when opening an estimate file.
One final comment about Excel 2007 security. Typically Excel expect to open files with
certain extensions. Because our software uses a unique extension, i.e. .est, Excel will display
the following message upon opening a MEI Estimation file. When this message is displayed,
simply select Yes and proceed with opening the file.
If you have any security related questions or comments please feel free to send us an email
or give us a call.