Re: Application.Quit

Tech-Archive recommends: Fix windows errors by optimizing your registry

Oh, yes. What I was thinking was EnableEvents = False. Sorry.
--
I am running on Excel 2003, unless otherwise stated.


"Mike H" wrote:

Stopping display alerts will have no impact on events

"Orion Cochrane" wrote:

The example you gave with turning display alerts off may have been used; use
the activeworkbook.close savechanges:=true example instead. Take out the
application.displayalerts=false line. You can also use ThisWorkbook instead
of ActiveWorkbook to narrow it down to the workbook containing the macro.
--
I am running on Excel 2003, unless otherwise stated. Please rate posts so we
know when we have answered your questions. Thanks.


"Mike H" wrote:

It sounds like your disabling events somewhere when you close this book and
they remain disabled until the application is closed and re-opened. I suspect
you have other code somwhere in this book.

Mike

"kirkm" wrote:

On Fri, 17 Oct 2008 00:55:00 -0700, Mike H
<MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi,

Activeworkbook.close

Thanks Mike, that did work but had an odd side effect.

If I open the workbook again, none of the double click events
work. (Until I close and Open Excel again).

These usually fire 'Private Sub Worksheet_BeforeDoubleClick'.
but this is completly bypassed somehow.

I wonder why, any idea?

Thanks - Kirk

.

Quantcast