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
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