Thread: pop up box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MillyD MillyD is offline
external usenet poster
 
Posts: 24
Default pop up box

Cheers


"DS-NTE" wrote in message
...
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