Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off Close Button
How do I turn-off the X "Close button" on a form so that it looks like a
dialog form |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off Close Button
Hi Ayo,
To hide the Userform's X icon, try downloading Stephen Bullen's FormFun.zip file at: Stephen Bullen's Excel Page http://www.oaltd.co.uk/Excel/Default.htm To disable the icon, in the Userform module try something like: '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True End If End Sub '<<========= However, preferable would be the following version wh9ich redirects the icon to the Userform's cbExit button: this allows any code linked to the close button to run, without annoying the typical user, who would expect thw icon to close the form. '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Call cbExit_Click End If End Sub '<<========= --- Regards. Norman "Ayo" wrote in message ... How do I turn-off the X "Close button" on a form so that it looks like a dialog form |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off Close Button
I don't want to disable the icon, I want to hide it completely so that the
userform looks like a splash screen. "Norman Jones" wrote: Hi Ayo, To hide the Userform's X icon, try downloading Stephen Bullen's FormFun.zip file at: Stephen Bullen's Excel Page http://www.oaltd.co.uk/Excel/Default.htm To disable the icon, in the Userform module try something like: '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True End If End Sub '<<========= However, preferable would be the following version wh9ich redirects the icon to the Userform's cbExit button: this allows any code linked to the close button to run, without annoying the typical user, who would expect thw icon to close the form. '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Call cbExit_Click End If End Sub '<<========= --- Regards. Norman "Ayo" wrote in message ... How do I turn-off the X "Close button" on a form so that it looks like a dialog form |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off Close Button
Hi Ayo,
Try Stephen Bullen's: NoCloseButton.zip http://www.oaltd.co.uk/Excel/Default.htm --- Regards. Norman "Ayo" wrote in message ... I don't want to disable the icon, I want to hide it completely so that the userform looks like a splash screen. "Norman Jones" wrote: Hi Ayo, To hide the Userform's X icon, try downloading Stephen Bullen's FormFun.zip file at: Stephen Bullen's Excel Page http://www.oaltd.co.uk/Excel/Default.htm To disable the icon, in the Userform module try something like: '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True End If End Sub '<<========= However, preferable would be the following version wh9ich redirects the icon to the Userform's cbExit button: this allows any code linked to the close button to run, without annoying the typical user, who would expect thw icon to close the form. '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Call cbExit_Click End If End Sub '<<========= --- Regards. Norman "Ayo" wrote in message ... How do I turn-off the X "Close button" on a form so that it looks like a dialog form |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off Close Button
Thanks. I will try it.
"Norman Jones" wrote: Hi Ayo, Try Stephen Bullen's: NoCloseButton.zip http://www.oaltd.co.uk/Excel/Default.htm --- Regards. Norman "Ayo" wrote in message ... I don't want to disable the icon, I want to hide it completely so that the userform looks like a splash screen. "Norman Jones" wrote: Hi Ayo, To hide the Userform's X icon, try downloading Stephen Bullen's FormFun.zip file at: Stephen Bullen's Excel Page http://www.oaltd.co.uk/Excel/Default.htm To disable the icon, in the Userform module try something like: '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True End If End Sub '<<========= However, preferable would be the following version wh9ich redirects the icon to the Userform's cbExit button: this allows any code linked to the close button to run, without annoying the typical user, who would expect thw icon to close the form. '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Call cbExit_Click End If End Sub '<<========= --- Regards. Norman "Ayo" wrote in message ... How do I turn-off the X "Close button" on a form so that it looks like a dialog form |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off Close Button
Norman,
Don't think Stephen has that working for v2007, because I just tried it. Rob "Norman Jones" wrote in message ... Hi Ayo, Try Stephen Bullen's: NoCloseButton.zip http://www.oaltd.co.uk/Excel/Default.htm --- Regards. Norman "Ayo" wrote in message ... I don't want to disable the icon, I want to hide it completely so that the userform looks like a splash screen. "Norman Jones" wrote: Hi Ayo, To hide the Userform's X icon, try downloading Stephen Bullen's FormFun.zip file at: Stephen Bullen's Excel Page http://www.oaltd.co.uk/Excel/Default.htm To disable the icon, in the Userform module try something like: '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True End If End Sub '<<========= However, preferable would be the following version wh9ich redirects the icon to the Userform's cbExit button: this allows any code linked to the close button to run, without annoying the typical user, who would expect thw icon to close the form. '======== Private Sub UserForm_QueryClose( _ Cancel As Integer, _ CloseMode As Integer) If CloseMode = vbFormControlMenu Then Call cbExit_Click End If End Sub '<<========= --- Regards. Norman "Ayo" wrote in message ... How do I turn-off the X "Close button" on a form so that it looks like a dialog form |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turning off Close Button
Hi Rob,
You are correct that the NoCloseButton utility does not work with Excel 2007 (or, at least in my case, with the Excel 2007 / Windows Vista combination) . In this connection, you may note that Stephen shows the last update of the utility as 25 November 1998. --- Regards. Norman "RobN" wrote in message ... Norman, Don't think Stephen has that working for v2007, because I just tried it. Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Close Button | Excel Discussion (Misc queries) | |||
Userform + close button | Excel Discussion (Misc queries) | |||
close button does not close | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |