open a workbook without running Workbook_Open macro in E2007

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
 
J

Jacob Skaria

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

If this post helps click Yes
 
A

Andreas

Hi Jacob,

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

Andreas
 
G

Gord Dibben

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
 
G

Gord Dibben

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
 
A

Andreas

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

Regards,
Andreas
 
A

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
 
G

Gord Dibben

Thank you.

Appears I am only SP1'd

Have downloaded SP2 and will install later.


Gord
 
G

Gord Dibben

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
 

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

Top