Thanks for your post Jim. I think from your extensive tests - and the
fact that nobody answered my previous post or Kristian's earlier post
on this topic - I have to conclude that no-one can reproduce this.

The factor which I realise I didn't mention is Citrix:

XL2000 basic (9.0.2720) is running on my local machine. In this
version there's no problem - the workbook won't close, as expected.
XL2000 SP3 (9.0.6926) is running on a Citrix server (Metaframe
Presentation Server 3.0). This is the version in which the problem
occurs - the workbook closes, even though Cancel has been set to True.

So it looks like Citrix is the obvious factor. Which seems odd: I
thought that Citrix was just a machine located elsewhere feeding
screen/mouse/keyboard input to the desktop. Maybe this assumption just
shows how little I know about Citrix - when I started out as an MS
developer 10 years ago I assumed that their products would do exactly
what they said they would, all the time...

It can't be something as simple as some equivalent of
Application.EnableEvents being set to False, because the event does
execute.

Think I'd better chase this up in a Citrix group.

thanks again


Seb