cancelling quit bug in Excel v.X and 2004

A

Aaron Graham

I have found a bug/crash in Excel v.X and 2004. If a
workbook_beforeclose macro sets cancel to true when called after the
user has told Excel to quit it is disregarded and possibly causes Excel
to crash.

Easy to reproduce
1.) new WB
2.) add before close macro that sets cancel = true
3.) either choose quit menu item or press command+Q
4.) Excel will still quit or it will crash if the WB is linked to from
other open wb's. Even if crash reporter does not detect the crash,
Excel will automatically reopen the wb the next time it is launched,
like it did crash.

Aaron Graham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top