pop up box
How do I put an information box on an excel worksheet which pops up
everytime you close a spreadsheet down |
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 |
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 |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com