I was thinking the OP could use a hidden userform and check the value of
CloseMode in the UserForm_QueryClose event for vbFormMDIForm, which I
supposed would be when Excel's main window is closed . However, XL2002 help
says "Note that vbFormMDIForm is also specified in the Object Browser, but
is not yet supported.".
Is it supported in XL2003 or 2007 ?
And if so, it is the correct value to look for ?

NickHK

"Wei Lu [MSFT]" wrote in message
...
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.