open a workbook without running Workbook_Open macro in E2007

  • Thread starter Thread starter Andreas
  • Start date Start date
A

Andreas

Hi all,

in Excel versions before E2007 it was possible to open a workbook without
running the "Workbook_Open" macro by holding the "Shift" key. This does not
seem to work any longer in Excel 2007. Macro Settings in the Trust Center are
set to "Enable all macros".

Does anybody know a workaround?

Thanks for your help.

Andreas
 
If you have any other macros with hot key having Shift combination remove
that and try.

If this post helps click Yes
 
Hi Jacob,

thanks for your tip. Unfortunately, it does not help. Workbook_Open still
runs.

Andreas
 
I cannot replicate your problem.

I have a workbook.xlsm with Workbook_Open code.

Private Sub Workbook_Open()
MsgBox "hoohah"
End Sub

If I hold the shift key while opening, the code does not fire, else it does
fire.


Gord Dibben MS Excel MVP
 
Ron

Must be I have the latest updates.

Where do I see what SP I am running.................used to be Help>About

Can't find that!!


Gord
 
I am running Excel 2007 SP2 (12.0.6504.5001 SP2 MSO 12.0.6425.1000 - if that
info helps further)

Regards,
Andreas
 
UPDATE:

I could prevent the Workbook_Open macro from running in a new workbook!
Since I cannot stop it from running in my existing one, it must be something
in that workbook. I'll have to go investigating myself. Will keep you posted.

Thanks all for your input

Regards,
Andreas


Andreas said:
I am running Excel 2007 SP2 (12.0.6504.5001 SP2 MSO 12.0.6425.1000 - if that
info helps further)

Regards,
Andreas
Click to expand...
 
Now SP2'd

SHIFT key and open stops macros same as before with SP1

I don't know what which version of Excel 2007 allowed macros to run when
shift key help down.

Must have been pre-SP1 but I would think SP1 is original install from disk?


Gord
 
Back
Top