Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DISABLE CLOSE MSGBOX ON CLICK "X"
How to disable the close option with "X" in a msgbox -- sal2 ----------------------------------------------------------------------- sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204 View this thread: http://www.excelforum.com/showthread.php?threadid=26318 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DISABLE CLOSE MSGBOX ON CLICK "X"
"sal21" wrote in message ... How to disable the close option with "X" in a msgbox? the following works for a userform... not sure if it would work for a msgbox: - Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True End Sub hth, tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
Disable "save" option on close. | Excel Discussion (Misc queries) | |||
MsgBox Prompt w/ No "X" to close | Excel Programming | |||
Disable "Save" &/or "Close" | Excel Programming | |||
SIMPLEST way to disable "close" button on form? | Excel Programming |