Hi

I'm automating Excel from VB, populating a sheet and then showing the user.
The user may or may not make chnages to this sheet. When the user closes
Excel, the user is not prompted to save changes, but rather Excel closes
down without asking. Is there a flag or something I can set to force Excel
to prompt for save changes if any changes have occurred to this sheet.

Thanks

Simon