pop up box

M

MillyD

How do I put an information box on an excel worksheet which pops up
everytime you close a spreadsheet down
 
D

DS-NTE

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
 
M

MillyD

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
Blue screen error message 1
Information box 1
pop up box 1
Dialog Pop Up Box 1
Help Text in an Excel 2003 or 2007 Worksheet 3
Excel Providing user message when RED X clicked & properly closing application. 2
How do i return muliple lines of data. 3

Top