Workbook_Open

[BobS]

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

 

[Chip Pearson]

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)

 

[BobS]

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

Any ideas?

thanks

 

[Chip Pearson]

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)

 

[Ron de Bruin]

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.