ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable macros (https://www.excelbanter.com/excel-programming/317239-disable-macros.html)

Otto Moehrbach[_6_]

Disable macros
 
Excel 2002, WinXP
I am opening a file with VBA and I want to open it with macros disabled. A
Google search of this subject gave me the following statement:
Application.AutomationSecurity = msoAutomationSecurityForceDisable

But this statement appears to be doing nothing about the macros in the file.
How would I use this statement, or another statement, if I want to open
MyFile.xls with macros disabled?
Thanks for your help. Otto




All times are GMT +1. The time now is 02:34 PM.

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