Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! - Closing form
Hi Katie,
Private Sub UserForm_QueryClose(Cancel As Integer, _ CloseMode As Integer) If CloseMode < vbFormCode Then MsgBox "This exit is shut due to fallen trees" Cancel = True End If End Sub Instead of the msgbox, you could call your own close routine and checks. --- Regards, Norman "Katie" wrote in message ... I have a few forms in Excel that I do not want the user to be able to close without going through the questions asked on the form. As I have it running now, a user can click the "x" in the top right hand corner and the form will close. How do I disable this? thank you! I am frustrated - this is the last thing I need to figure out and I am sure it is so easy, but I can NOT figure it out! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically close form before closing | Excel Discussion (Misc queries) | |||
Closing a Form | Excel Discussion (Misc queries) | |||
closing form semi permantly | Excel Programming | |||
closing form w/ Maco | Excel Programming | |||
need form to initialize without closing | Excel Programming |