Workbook_Open

  • Thread starter Thread starter Paul Ilacqua
  • Start date Start date
P

Paul Ilacqua

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

Paul
 
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.
 
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
 
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>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shift key to disable macros 1
Open workbook without running Workbook_Open Event 4
Workbook_Open 4
open a workbook without running Workbook_Open macro in E2007 10
Excel 2007 autoopen shift key doesn't work 2
Excel Macro to un-mute Audio/speakers. 15
Saving A Copy 2
Runtime error 1004: Select method of worksheet class failed 3

Back
Top