| Home |
| Search |
| Today's Posts |
|
#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 |
Threaded Mode
