I'm new to Excel 2007... has the ability to prevent events from firing when
ooening a file using the shift key no longer available? Any other ways of
doing this? If not how do we now get into our macros for editing and testing
if we cannot prevent workbook_open event from firing?

thanks

As far as I know, the SHIFT key method still works. However, you can
always disable events, open your workbook, and then re-enable events.
In the VBA editor, press CTRL G to open the Immediate window. There,
type the following and press ENTER:

Application.EnableEvents = False

Then, open the workbook. Once it is open, restore event handling. Type
the following into the Immediate window and press ENTER:

Application.EnableEvents = True

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Wed, 4 Nov 2009 15:51:22 -0500, "BobS"
wrote:

I'm new to Excel 2007... has the ability to prevent events from firing when
ooening a file using the shift key no longer available? Any other ways of
doing this? If not how do we now get into our macros for editing and testing
if we cannot prevent workbook_open event from firing?

thanks

There must be some setting somewhere then because shift just does not work
for me.

Any ideas?

thanks

No ideas. It works for me in XL2007, Win 7 Ultimate.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 4 Nov 2009 18:26:18 -0500, "BobS"
wrote:

There must be some setting somewhere then because shift just does not work
for me.

Any ideas?

thanks

Is working OK here also but after 2007 was released I read about this problem more in the newsgroup.
I was never able to reproduce it.

--

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


"Chip Pearson" wrote in message ...
No ideas. It works for me in XL2007, Win 7 Ultimate.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 4 Nov 2009 18:26:18 -0500, "BobS"
wrote:

There must be some setting somewhere then because shift just does not work
for me.

Any ideas?

thanks