ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Security setting of low ignored for macros (https://www.excelbanter.com/excel-programming/285203-security-setting-low-ignored-macros.html)

Jonathan Cohen

Security setting of low ignored for macros
 
I have an application that use a macro to format and build
a report based on other sheets in the workbook.
Unfortunately the macro doesn't run because it fails the
security test. So I set the security level in Excel to low
allowing everything to pass through but I still get a
security too high error. Any suggestions? Thanks

Wei-Dong Xu [MSFT]

Security setting of low ignored for macros
 
Hi Jonathan,

Thank you for posting in MSDN managed newsgroup!

I'd suggest the kb article will help you a lot regarding this issue. This article introduces the method to disable the macro warning dialog. Please go to:
317405 OFFXP: How to Implement Application.AutomationSecurity
http://support.microsoft.com/?id=317405

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.




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

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