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