View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt[_2_] Matt[_2_] is offline
external usenet poster
 
Posts: 6
Default Disable macros on a programmatically opening .xls file

If I am opening an .xls file using code (VBA), how can I disable the macro's
from running on it programmatically? I tried ".AutomationSecurity =
msoAutomationSecurityForceDisable" but this kills my macro in the middle of
itself running as well?

Sorry for the bold, I cant turn it off for some reason.

Matt