Create an event handler for Before_Close event in workbook's code.
Show an user-defined Userform

HTH
--
AP

"Bernadette" a écrit dans le message
de news: ...
I would like to create a pop up box simular to the one that appears when
you
are closing your document and are asked to save. Is there a function to
allow you to create your own pop up window and questions?