LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Workbook_BeforeClose: Cancel doesn't work

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbook_BeforeClose(Cancel As Boolean) - Cancel won't work gpmichal Setting up and Configuration of Excel 1 May 12th 09 02:33 AM
Can't get Cancel to work in message box * Kenneth * Excel Discussion (Misc queries) 1 March 30th 06 08:10 PM
Workbook_BeforeClose - Cancel not working sebt Excel Programming 0 January 31st 06 04:36 PM
Workbook_BeforeClose doesn't work!!! [email protected] Excel Programming 3 October 17th 05 03:28 PM
Detecting a cancel on Workbook_BeforeClose event? Don Wiss Excel Programming 3 January 18th 05 12:49 PM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"