pop up box

  • Thread starter Thread starter MillyD
  • Start date Start date
M

MillyD

How do I put an information box on an excel worksheet which pops up
everytime you close a spreadsheet down
 
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
 
Cheers


DS-NTE said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Information Box 3
pop up box 1
Dialog Pop Up Box 1
Blue screen error message 1
Excel Providing user message when RED X clicked & properly closing application. 2
Turn off prompts 1
Information box 1
How do i return muliple lines of data. 3

Back
Top