ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Security Alert Window Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/153806-security-alert-window-excel-2007-a.html)

KT

Security Alert Window Excel 2007
 
We have our Macro Settings set to Disable all Macros with notification. When
a user opens a file with macros, they recieve the Security Warning message
bar. Then can then choose the "Options" button to open the "Security Alert -
Macros & ActiveX" window to select their next steps.

Is there a way to bypass the message bar so that users immediately see the
"Security Alert - ..." window? Our users don't notice the message bar.

JLatham

Security Alert Window Excel 2007
 
"Is there a way..." Sorry, not that I'm aware of at this time. I'm with your
users on this one - there are times I don't notice the message bar either.
Probably would have helped if they'd arranged to have it some bright, bold
color that contrasts with the current color scheme in use.

Have you looked into using 2007's ability to designate Trusted Zones and
storing your workbook(s) with code in them? When a file is in a trusted
location, macros are enabled by default regardless of their source or digital
signature status.

"KT" wrote:

We have our Macro Settings set to Disable all Macros with notification. When
a user opens a file with macros, they recieve the Security Warning message
bar. Then can then choose the "Options" button to open the "Security Alert -
Macros & ActiveX" window to select their next steps.

Is there a way to bypass the message bar so that users immediately see the
"Security Alert - ..." window? Our users don't notice the message bar.



All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com