Re: Capture close excel event in .xla

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I didn't know about that bug, but I can confirm that I do have SR-1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tournifreak" <wendyjon@xxxxxxxxxxxx> wrote in message
news:ac115850-be80-424b-96e4-4c3ff7cd7ac5@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On 15 Jul, 10:25, "Bob Phillips" <bob....@xxxxxxxxxxxxx> wrote:
Just noticed your comment re Excel 2000, so I tried it there, and it
still
worked.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Tournifreak" <wendy...@xxxxxxxxxxxx> wrote in message

news:9ab1bd70-f15b-4be1-bd87-3efbd9817e07@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi - I hope someone can help.

I'm trying to capture the event where someone closes Excel (using the
red "X"). My code is in an .xla and no other workbooks are open except
the hidden .xla.

My code is in "This Workbook" of the hidden .xla

I've tried:
Workbook_BeforeClose(Cancel As Boolean)
Workbook_WindowDeactivate(ByVal Wn As Window)
Workbook_Deactivate()
Workbook_SheetDeactivate(ByVal Sh As Object)

None are captured - Excel just shuts down without triggering.

The funny thing is, Workbook_Open() does trigger when the xla is
opened.

I'm using Excel 2000 if it makes any difference. Does anyone have any
ideas?

Thanks & regards,
Jon.

Hi Bob,
I just found this:
http://support.microsoft.com/kb/q248172/

Seems like this is a bug with the original release of Excel 2000. I'm
not sure if I have the service pack installed, so I'll install it
anyway and report back. Thanks for your help,
Jon.


.

Relevant Pages

  • Re: Error in Excel Calculations?
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... A3 is =A1-A2 ... aside from notifying Microsoft about this bug in order for them to ...
    (microsoft.public.excel)
  • Re: Capture close excel event in .xla
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... My code is in an .xla and no other workbooks are open except ... Seems like this is a bug with the original release of Excel 2000. ...
    (microsoft.public.excel.programming)
  • Re: Capture close excel event in .xla
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... My code is in an .xla and no other workbooks are open except ... not sure if I have the service pack installed, ...
    (microsoft.public.excel.programming)
  • Re: sum addition function
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Thanks Bob but this does not work. ... It may be bug. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel 2003 calculation bug - subtraction of 1 decimal place
    ... It is not a bug, it is floating point arithmetic, ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... I think I have found a bug on Excel 2003, but I am not sure if it is ...
    (microsoft.public.excel)