Thread: Disable macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default 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