All,
Had a very curious event occur today.

Selected Worksheet_Change event macro on a sheet and put
breakoint on its title line.

Added a Watch expression for Application.EnableEvents, All
procedures, All modules.

Made a change on the sheet (using a cell with Validation).

Result:
EXCEL VANISHED! No errors, no warning, nothing.
I am not dreaming - this is repeatable!

Have done a Google serach and a MS KB search with no hits.
Any thoughts from the MVP community?
(besides of course, DON'T DO THAT!)

Thanks for you help,
Bewildered (Alex J)

Note:
More Testing indicates that the problem ocurs without the
watch in place - some confilict between validation and the
breakpoint on the event processing code?
Alex J

-----Original Message-----
All,
Had a very curious event occur today.

Selected Worksheet_Change event macro on a sheet and put
breakoint on its title line.

Added a Watch expression for Application.EnableEvents,
All
procedures, All modules.

Made a change on the sheet (using a cell with Validation).

Result:
EXCEL VANISHED! No errors, no warning, nothing.
I am not dreaming - this is repeatable!

Have done a Google serach and a MS KB search with no hits.
Any thoughts from the MVP community?
(besides of course, DON'T DO THAT!)

Thanks for you help,
Bewildered (Alex J)
.

Alex

I couldn't reproduce it. XL2000 on Win98SE, data validation with list in
A1, change event with breakpoint on Sub line and one line below for a
message box.

Result is that the VBE is opened and in debug mode on the breakpoint.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"aLEX j" wrote in message
...
Note:
More Testing indicates that the problem ocurs without the
watch in place - some confilict between validation and the
breakpoint on the event processing code?
Alex J

-----Original Message-----
All,
Had a very curious event occur today.

Selected Worksheet_Change event macro on a sheet and put
breakoint on its title line.

Added a Watch expression for Application.EnableEvents,
All
procedures, All modules.

Made a change on the sheet (using a cell with Validation).

Result:
EXCEL VANISHED! No errors, no warning, nothing.
I am not dreaming - this is repeatable!

Have done a Google serach and a MS KB search with no hits.
Any thoughts from the MVP community?
(besides of course, DON'T DO THAT!)

Thanks for you help,
Bewildered (Alex J)
.

Dick,

Found the cause and worked around it. Has to do with a dynamic range
(calculated with a VBA function using application.volatile) being declared
as a range variable in the Worksheet_Change function. There is some error in
the function which causes the crash.

Since the problem has nothing to do with the title of the thread, I will
stop this thread and start another with more accurate information for the
group.

I must say, though, I have never seen XL2000 go completely t-ts up and
dissapear like this before. I must have hit the motherlode of critical
errors.

Thanks a lot for your response,

Alex J


"Dick Kusleika" wrote in message
...
Alex

I couldn't reproduce it. XL2000 on Win98SE, data validation with list in
A1, change event with breakpoint on Sub line and one line below for a
message box.

Result is that the VBE is opened and in debug mode on the breakpoint.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"aLEX j" wrote in message
...
Note:
More Testing indicates that the problem ocurs without the
watch in place - some confilict between validation and the
breakpoint on the event processing code?
Alex J

-----Original Message-----
All,
Had a very curious event occur today.

Selected Worksheet_Change event macro on a sheet and put
breakoint on its title line.

Added a Watch expression for Application.EnableEvents,
All
procedures, All modules.

Made a change on the sheet (using a cell with Validation).

Result:
EXCEL VANISHED! No errors, no warning, nothing.
I am not dreaming - this is repeatable!

Have done a Google serach and a MS KB search with no hits.
Any thoughts from the MVP community?
(besides of course, DON'T DO THAT!)

Thanks for you help,
Bewildered (Alex J)
.