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
|