Macro Security

NOTE: After setting your security level, you will need to close and reopen Excel.

Open a blank Excel workbook and go to:
Tools/Options/Security/Macro Security or
Tools/Macro/Security (depending on your version of Excel).
If the security level is set to Very High or High, change it to Medium (if not set to Very High or High, then leave the settings as you find them and "cancel").
This will allow you to use the macros in any of our tools.
It is okay to leave the security level at the "Medium" level because it will always ask you if you want to proceed if you open an Excel file that contains macros.
For this change to take effect, you will need to close and reopen Excel.

Open Excel 2007
Click on the 'Office Button' located in the top left corner
Click on the 'Excel Options' button
Select 'Trust Center' on the left side of the 'Excel Options' screen.
Click the 'Trust Center Settings' button on the right
Select 'Macro Settings' on the left side of the 'Trust Center' screen
Under 'Macro Settings', select 'Disable all macros except digitally signed macros'
Select 'External Contents' on the left side of the 'Trust Center' screen
Under 'Security settings for Data Connections', select 'Enable all Data Connections'
Click the 'OK' button on both the 'Trust Center' and 'Excel Options' screens to save

Open Excel 2010
Click on the 'Office Button' located in the top left corner
Click on the 'File' menu
Select the 'Options' item
Select 'Trust Center' on the left side of the 'Excel Options' screen.
Click the 'Trust Center Settings' button on the right
Select 'Macro Settings' on the left side of the 'Trust Center' screen
Under 'Macro Settings', select 'Disable all macros except digitally signed macros'
Select 'External Contents' on the left side of the 'Trust Center' screen
Under 'Security settings for Data Connections', select 'Enable all Data Connections'
Click the 'OK' button on both the 'Trust Center' and 'Excel Options' screens to save

Files 0

Images 0
No images to display in the gallery.

You must login to post a comment.