View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Remy[_3_] Remy[_3_] is offline
external usenet poster
 
Posts: 18
Default Disable Macros when loading a Workbook in Excel 2000

Hey
Is there a way to switch off macros when you open a workbook with Excel
2000 via Automation?
I know there is the
excelApp.AutomationSecurity =
soAutomationSecurity.msoAutomationSecurityForceDis able;
in Excel 2003, but that is not around for 2000 yet.
Also, setting
EnableEvents = false
is not working either. Seems to be a bug according to MS.

Thanks

Remy Blaettler
www.collaboral.com