![]() |
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