Office 2007- Setting Macro Security

Excel 2007 works differently than previous versions of Excel. In order to allow the buttons and macros to work correctly in your CCI spreadsheets, you will need to complete the procedure listed below on each PC that has Office 2007 and is using the CCI spreadsheets. This procedure needs to only be done once on each PC.

Click on the Office button located in the upper left hand corner in Excel 2007.



Click on the Excel Options button that will be located at the bottom of the drop-down list that appears.


Select Trust Center on the left menu.


Select Trusted Locations from the menu on the left.


Click on the Add new location button.


Enter the location of your AS/400 spreadsheets- this is normally C:\AS400DA. Place a checkmark to allow subfolders of this location.

Click on OK.

Click OK three times to completely exit the trust center.