Macro/Trust Center Settings
I have a spreadsheet created in Excel 2003 in which I display a message to
users indicating that the macro security level was not set to either Medium
or Low. Basically, it functions because the WorkbookOpen event does not fire
if the setting is on High. Now that I have moved "up" to Excel 2007, the
process does not work to display the message.
Is there a way to simply read the setting in the Trust Center/Macro
Security/Macro Settings? I am not looking to change the setting, just be
able to see what it is so that I can display an appropriate message.
Thanks.
|