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.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

--

Dave Peterson