Thank you very much folks, but I couldn't get it to work. The sheet just
closed like always.

"Mike H" wrote:


Hi,

I should have said, Right click the sheet tab, view code, double click the
appropriate sheet and paste the code in.

Mike


"stevieboy1313" wrote:

I have read some suggestions for a pop-up box when opening a sheet, but how
can I create a message box that appears when you close the worksheet? Any
help will be appreciated.