LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 336
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what is the file name where my settings of the trust center? Brigitte[_2_] Excel Discussion (Misc queries) 0 March 5th 09 05:11 AM
Macro Trust Center Un-Available DOUG Excel Discussion (Misc queries) 3 January 22nd 09 03:39 PM
Trust Center settings via GPO D2k Setting up and Configuration of Excel 0 January 14th 08 03:03 PM
Macro trust center problems in Excel 2007 David Walker Setting up and Configuration of Excel 1 January 9th 08 01:13 AM
Trust center log David Walker Setting up and Configuration of Excel 1 January 5th 08 02:06 AM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"