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
---------------
Jacob Skaria


"Andreas" wrote:

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

Hi Jacob,

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

Andreas



"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"Andreas" wrote:

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

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

On Sun, 5 Jul 2009 10:07:00 -0700, Andreas
wrote:

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

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" <gorddibbATshawDOTca wrote in message ...
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

On Sun, 5 Jul 2009 10:07:00 -0700, Andreas
wrote:

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

Ron

Must be I have the latest updates.

Where do I see what SP I am running.................used to be HelpAbout

Can't find that!!


Gord

On Sun, 5 Jul 2009 21:36:46 +0200, "Ron de Bruin"
wrote:

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

hi
office buttonexcel optionsresource groupabout

Regards
FSt1

"Gord Dibben" wrote:

Ron

Must be I have the latest updates.

Where do I see what SP I am running.................used to be HelpAbout

Can't find that!!


Gord

On Sun, 5 Jul 2009 21:36:46 +0200, "Ron de Bruin"
wrote:

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

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

Regards,
Andreas


"Ron de Bruin" wrote:

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" <gorddibbATshawDOTca wrote in message ...
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

On Sun, 5 Jul 2009 10:07:00 -0700, Andreas
wrote:

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

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" wrote:

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

Regards,
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

Thank you.

Appears I am only SP1'd

Have downloaded SP2 and will install later.


Gord

On Sun, 5 Jul 2009 13:48:01 -0700, FSt1
wrote:

hi
office buttonexcel optionsresource groupabout

Regards
FSt1

"Gord Dibben" wrote:

Ron

Must be I have the latest updates.

Where do I see what SP I am running.................used to be HelpAbout

Can't find that!!


Gord

On Sun, 5 Jul 2009 21:36:46 +0200, "Ron de Bruin"
wrote:

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

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

On Tue, 07 Jul 2009 09:23:59 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Thank you.

Appears I am only SP1'd

Have downloaded SP2 and will install later.


Gord

On Sun, 5 Jul 2009 13:48:01 -0700, FSt1
wrote:

hi
office buttonexcel optionsresource groupabout

Regards
FSt1

"Gord Dibben" wrote:

Ron

Must be I have the latest updates.

Where do I see what SP I am running.................used to be HelpAbout

Can't find that!!


Gord

On Sun, 5 Jul 2009 21:36:46 +0200, "Ron de Bruin"
wrote:

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