open a workbook without running Workbook_Open macro in E2007

[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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Andreas]

Hi Jacob,

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

Andreas

 

[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

 

[Ron de Bruin]

I saw that problem also a long time ago with testing but it seems to be fixed if you run the latest updates

For Andreas
What Service Pack are you running

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

 

[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

 

[FSt1]

hi
office button>excel options>resource group>about

Regards
FSt1

 

[Andreas]

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

Regards,
Andreas

 

[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

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

Regards,
Andreas

 

[Gord Dibben]

Thank you.

Appears I am only SP1'd

Have downloaded SP2 and will install later.


Gord

 

[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