Prev: treeview control problems
Next: Issue with expired digital certificate ..
From: Domenick on 12 May 2010 14:44
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.
From: Ron de Bruin on 12 May 2010 14:50
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(a)discussions.microsoft.com> wrote in message news:BC6B1847-2003-4D1E-A622-D1AC7F104E1B(a)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.
From: p45cal on 12 May 2010 14:53

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



D
o
m
e
n
i
c
k
;
7
2
2
4
4
0

W
r
o
t
e
:


>
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

From: B Lynn B on 12 May 2010 15:37
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.
From: Domenick on 13 May 2010 10:27
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.
 |  Next  |  Last
Pages: 1 2
Prev: treeview control problems
Next: Issue with expired digital certificate ..