I'm using Excel 2007. How do I open a workbook (the workbook is a .xls 
97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down 
the SHIFT key while opening as this worked in previous versions of Excel, but 
the event still runs (unfortunately, there is an ActiveWorkbook.Close at the 
end of my code so I can't get in to modify it :(

I'm sure there is a simple way to do this in 2007 but I do not know it. 
Thanks for the help.

Hi Domenick

I read more about this problem
Works OK for me when I use Office Button>Open and hold the Shift key

Change your security so you have the option to disable Macro's



-- 

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



"Domenick" <Domenick@discussions.microsoft.com> wrote in message news:BC6B1847-2003-4D1E-A622-D1AC7F104E1B@microsoft.com...
> I'm using Excel 2007. How do I open a workbook (the workbook is a .xls 
> 97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down 
> the SHIFT key while opening as this worked in previous versions of Excel, but 
> the event still runs (unfortunately, there is an ActiveWorkbook.Close at the 
> end of my code so I can't get in to modify it :(
> 
> I'm sure there is a simple way to do this in 2007 but I do not know it. 
> Thanks for the help. 

Disable Macros? If you automatically enable them then you'll have to
change the security level first. You can still edit vba and save. 



Domenick;722440 Wrote: 
> 
I'm using Excel 2007. How do I open a workbook (the workbook is a .xls
> 97-2003 format) WITHOUT running the Workbook_Open event? I tried
holding down
> the SHIFT key while opening as this worked in previous versions of
Excel, but
> the event still runs (unfortunately, there is an ActiveWorkbook.Close
at the
> end of my code so I can't get in to modify it :(
> 
> I'm sure there is a simple way to do this in 2007 but I do not know
it.
> Thanks for the help.


-- 
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202323

http://www.thecodecage.com/forumz

There are lots of times when I don't want events to "fire" besides just 
workbook open, so I've put a little sub in my personal.xlsb to toggle 
Application.EnableEvents between True and False, and assigned it to a custom 
button on my quick launch toolbar.  Then I just open Excel and click the 
custom button to disable events before opening a file where I don't want the 
Open event code to run.

"Domenick" wrote:

> I'm using Excel 2007. How do I open a workbook (the workbook is a .xls 
> 97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down 
> the SHIFT key while opening as this worked in previous versions of Excel, but 
> the event still runs (unfortunately, there is an ActiveWorkbook.Close at the 
> end of my code so I can't get in to modify it :(
> 
> I'm sure there is a simple way to do this in 2007 but I do not know it. 
> Thanks for the help.

That's a good suggestion. Just curious: Does your custom button indicate 
whether the EnableEvents is ON or OFF (perhaps "pushed in" for ON)? If so, 
how did you do this? Thanks.

"B Lynn B" wrote:

> There are lots of times when I don't want events to "fire" besides just 
> workbook open, so I've put a little sub in my personal.xlsb to toggle 
> Application.EnableEvents between True and False, and assigned it to a custom 
> button on my quick launch toolbar.  Then I just open Excel and click the 
> custom button to disable events before opening a file where I don't want the 
> Open event code to run.
> 
> "Domenick" wrote:
> 
> > I'm using Excel 2007. How do I open a workbook (the workbook is a .xls 
> > 97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down 
> > the SHIFT key while opening as this worked in previous versions of Excel, but 
> > the event still runs (unfortunately, there is an ActiveWorkbook.Close at the 
> > end of my code so I can't get in to modify it :(
> > 
> > I'm sure there is a simple way to do this in 2007 but I do not know it. 
> > Thanks for the help.

Private Sub CommandButton1_Click()
With Application
    If .EnableEvents = True Then
        .EnableEvents = False
        CommandButton1.Caption = "Disabled"
    Else
        .EnableEvents = True
        CommandButton1.Caption = "Enabled"
    End If
End With
End Sub


Gord Dibben  MS Excel MVP

On Thu, 13 May 2010 07:27:01 -0700, Domenick
<Domenick@discussions.microsoft.com> wrote:

>That's a good suggestion. Just curious: Does your custom button indicate 
>whether the EnableEvents is ON or OFF (perhaps "pushed in" for ON)? If so, 
>how did you do this? Thanks.
>
>"B Lynn B" wrote:
>
>> There are lots of times when I don't want events to "fire" besides just 
>> workbook open, so I've put a little sub in my personal.xlsb to toggle 
>> Application.EnableEvents between True and False, and assigned it to a custom 
>> button on my quick launch toolbar.  Then I just open Excel and click the 
>> custom button to disable events before opening a file where I don't want the 
>> Open event code to run.
>> 
>> "Domenick" wrote:
>> 
>> > I'm using Excel 2007. How do I open a workbook (the workbook is a .xls 
>> > 97-2003 format) WITHOUT running the Workbook_Open event? I tried holding down 
>> > the SHIFT key while opening as this worked in previous versions of Excel, but 
>> > the event still runs (unfortunately, there is an ActiveWorkbook.Close at the 
>> > end of my code so I can't get in to modify it :(
>> > 
>> > I'm sure there is a simple way to do this in 2007 but I do not know it. 
>> > Thanks for the help.