Setting Macro Security - MS Office 2007

Setting Macro Security - MS Office 2007

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.


 

    • Related Articles

    • Setting Macro Security- Office 2010/2016/2019

      Setting Macro Security- Office 2010/2016/2019 At the top, click on “File.”   Then click on “Options.”   Look for and then click on “Trust Center.”   A box that says Microsoft Trust Center will pop up. In the lower right-hand corner of that box, you ...
    • Setting Macro Security - Excel 2016

      Setting Macro Security - Excel 2016 At the top Click on “File”   Then click on “Options”   Look for and then click on “Trust Center”   A box that says Microsoft Trust Center will pop up. In the lower right hand corner of that box you will need to ...
    • Avoiding the "security warning" when opening spreadsheets (enable content)

      When a spreadsheet is opened, if the message below is displayed, macro security has not been set.  There is another article in our solutions database about how to set this depending on the version of Office. (Issue:  You cannot click on the Red ...
    • Adding the Conditional Formatting in Office 2007/2010

      Adding the Conditional Formatting in Office 2007/2010 From the Home tab, click on Conditional Formatting, New Rule Select “Use a formula to determine which cells to format” And then type the formula =COUNTIF($C:$C,E23)=0 (where Column C is the column ...
    • Charting Board Report Information with Office 2007

      Charting Board Report Information with Office 2007 Click Attachments to view the document