Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My code includes the following.
Dim Message, Title, Response Message = "Entry must be numeric." Title = "Invalid Entry" Response = MsgBox(Message, Style, Title, Help, Ctxt) and, in a separate module, Sub Auto_Open() ' bunch of code Application.OnTime Now + TimeValue("00:00:30"), "Close_Workbook" ' more code End Sub Sub Close_Workbook() Application.DisplayAlerts = False ThisWorkbook.Close End Sub I want to guard against someone walking away without responding with an "OK" to the message. Is there a way I can get the workbook to automatically close while the MsgBox is still open? Thanks in advance. Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code to close an excel sheet without saving it .(via msgbox) | Excel Worksheet Functions | |||
Clear Auto Filter on Close (or open) | Excel Discussion (Misc queries) | |||
Auto filter using msgbox in macro not woking | Excel Discussion (Misc queries) | |||
Auto Open, Refresh, Save, Close | Excel Discussion (Misc queries) | |||
Novice - MsgBox Yes/No - Continue if Yes, Close if No | Excel Discussion (Misc queries) |