Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pop up box
How do I put an information box on an excel worksheet which pops up
everytime you close a spreadsheet down |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pop up box
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|