Disable Macros when loading a Workbook in Excel 2000

[Remy]

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]

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

 

[Tom Ogilvy]

Dave, I think he has tried that and is making reference to this article:

http://support.microsoft.com/default.aspx?scid=kb;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.

 

[Dave Peterson]

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

 

[Remy]

The problem is that the macro is executed in the Open event in Excel,
so until I can call a macro to switch of Macros, it's already too late.

Remy