Workbook_BeforeClose: Cancel doesn't work
I just tried it in Excel 97, 2000, 2002 and 2003 and in all four I was
unable to close the workbook. Interestingly I have the exact same version
of 2000 as you.
--
Jim
"sebt" wrote in message
oups.com...
| Hello
|
| I posted on this topic a month ago but have had no reply. Can anyone
| confirm this bug in Excel?
|
| To reproduce the bug:
|
| 1. New workbook
| 2. In the Workbook_BeforeClose event procedure of the workbook module,
| put this:
|
| Cancel=True
| MsgBox "Yes this event procedure is actually executing"
|
| 3. Close the workbook.
| 4. You get the MsgBox, but the workbook closes!
|
| Versions:
| BUG in XL2000 SP3 (9.0.6926 SP3)
| NO bug in XL2000 basic (9.0.2720)
|
| Kristian Mayville posted on this topic 21/07/2005 - he's found the
| problem in XL2003
| (11.6355.6360) SP1, VBA Retail 6.4.9972. No reply to him either.
|
| What can I do? MVPs, Microsoft, are you listening? (There nothing in
| the MS KB).
|
|
| seb
|
|