Workbook_Open

[Paul Ilacqua]

How do I cancel a Workbook_Open event in Excel 97. Holding the shift key
does not do it. Please help.

Paul

 

[GB]

You can turn on Macro virus protection in Tools .... Options

This will stop your macro working and you can then start up VBE and fix
whatever is wrong with it.

 

[Paul Ilacqua]

It's a simple call to a routine to pull in some data, but at the end it
closes EXCEL. I just want to be able to open the Workbook without running
the Worksheet_OPEN event. I know the Shift key should work, what are the
reasons as to why it would not? Thanks
Paul

 

[Dave Peterson]

I'm surprised the shift-key didn't work. (I try again and again and....)

But you could always go to the VBE (alt-F11),
then ctrl-G (to see the immediate window)
and type this
application.enableevents = false

then back to excel and open you workbook.

Remember to enableevents when you're done/ready.

(I'd still try the shift key one more time <vbg>)