If you want a pop-up before you close the workbook, try this

1)Open the WorkBook in Excel
2) Press Alt+F11
3) In the project explorer(Ctrl+R), Doubleclick ThisWorkbook
4) Copy paste the code below

Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "Closing down"
End Sub

"MillyD" skrev i melding
...
How do I put an information box on an excel worksheet which pops up
everytime you close a spreadsheet down