I remember skimming by that thread. Thanks for the solution (I'll speak for the
OP!).

Tom Ogilvy wrote:
>
> Dave, I think he has tried that and is making reference to this article:
>
> http://support.microsoft.com/default...b;en-us;211626
> XL2000: EnableEvents Property Does Not Work in Automation Server
>
> So the solution for that case is a macro run from within Excel that disables
> events. How that is implemented by the OP is their decision.
>
> --
> Regards,
> Tom Ogilvy
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:43A1B307.828858F7@verizonXSPAM.net...
> > Can you open the workbooks after you disable events:
> >
> > dim wkbk as workbook
> > application.enableevents = false
> > set wkbk = workbooks.open(...)
> > application.enableevents = true
> >
> > And if you do anything to the workbook, turn off events before you do it.
> >
> > Wouldn't that be the equivalent of disabling macros???
> >
> >
> >
> > Remy wrote:
> > >
> > > 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.msoAutomationSecurityForceDisable;
> > > 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
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson