fry
Active Member
- Joined
- Apr 25, 2007
- Messages
- 411
Hi All
I'm using the following code to try and get a popup window to give the user a warning that the workbook is about to shut down but I'm getting an "OK" button to be pressed.
Is there a setting that will just popup a window rather than you having to press a button...............and can the window size be specified???
Thanks for any help in advance
I'm using the following code to try and get a popup window to give the user a warning that the workbook is about to shut down but I'm getting an "OK" button to be pressed.
Is there a setting that will just popup a window rather than you having to press a button...............and can the window size be specified???
Thanks for any help in advance
Code:
Application.OnTime Now + TimeValue("00:00:20"), "close_workbook"
MsgBox "This Order Book will self destruct in 15 seconds...", vbExclamation, "User Notice"
Sub close_workbook()
Application.Quit
End Sub