Userform Close Button

RoyinUK2000 · Apr 2nd, 2002, 10:00 AM

Is it possible to stop a user shutting a userform with the close button.

Thx
Roy

Audiojoe · Apr 2nd, 2002, 10:01 AM

Yeah, just take the code out and watch their confused little face

RoyinUK2000 · Apr 2nd, 2002, 10:05 AM

I want to disable the close button if it is possible.

Thx
Roy The Boy

Audiojoe · Apr 2nd, 2002, 10:06 AM

Do you want it to do something else instead, or just stay on the page and do nothing when it's pressed?

RoyinUK2000 · Apr 2nd, 2002, 10:25 AM

I want it to stay on the sheet and remain active and tell the user that they cannot close it down by pressing the close button

Thx
Roy alias Reg

Audiojoe · Apr 2nd, 2002, 10:38 AM

Mmmkay....

The code you want is:

Private Sub CommandButton1_Click()

MsgBox ("You cannot close this form by pressing the close button")

End Sub

dan2 · Apr 2nd, 2002, 11:00 AM

Hmmm.........

Intreging!

I must know, why would you want the user to be stuck on a page only getting told that they cant go anywhere?

Dan.

Audiojoe · Apr 2nd, 2002, 11:10 AM

Are you into torture RoyInUK2000? I bet you've got a rack in your cellar...

RoyinUK2000 · Apr 2nd, 2002, 11:11 AM

The user wouldn't get stuck. The userform has 8 commandbuttons on it which move them on, so basically they must press one of the command buttons and not the close button. I only want to stop a user pressing the close button ( The cross in the corner ). Any other command button is fine

Come on someone out there must know the answer

Thax
Roy

Audiojoe · Apr 2nd, 2002, 11:13 AM

Oh THAT close button!! I thought you meant you'd drawn one on there and didn't want people pressing it. I thought that was a bit strange....

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 10:00 AM	#1
RoyinUK2000 Join Date: Mar 2002 Posts: 79	Is it possible to stop a user shutting a userform with the close button. Thx Roy

Apr 2nd, 2002, 10:01 AM	#2
Audiojoe Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Yeah, just take the code out and watch their confused little face

Apr 2nd, 2002, 10:05 AM	#3
RoyinUK2000 Join Date: Mar 2002 Posts: 79	I want to disable the close button if it is possible. Thx Roy The Boy

Apr 2nd, 2002, 10:06 AM	#4
Audiojoe Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Do you want it to do something else instead, or just stay on the page and do nothing when it's pressed?

Apr 2nd, 2002, 10:25 AM	#5
RoyinUK2000 Join Date: Mar 2002 Posts: 79	I want it to stay on the sheet and remain active and tell the user that they cannot close it down by pressing the close button Thx Roy alias Reg

Apr 2nd, 2002, 10:38 AM	#6
Audiojoe Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Mmmkay.... The code you want is: Private Sub CommandButton1_Click() MsgBox ("You cannot close this form by pressing the close button") End Sub

Apr 2nd, 2002, 11:00 AM	#7
dan2 Join Date: Mar 2002 Posts: 60	Hmmm......... Intreging! I must know, why would you want the user to be stuck on a page only getting told that they cant go anywhere? Dan.

Apr 2nd, 2002, 11:10 AM	#8
Audiojoe Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Are you into torture RoyInUK2000? I bet you've got a rack in your cellar...

Apr 2nd, 2002, 11:11 AM	#9
RoyinUK2000 Join Date: Mar 2002 Posts: 79	The user wouldn't get stuck. The userform has 8 commandbuttons on it which move them on, so basically they must press one of the command buttons and not the close button. I only want to stop a user pressing the close button ( The cross in the corner ). Any other command button is fine Come on someone out there must know the answer Thax Roy

Apr 2nd, 2002, 11:13 AM	#10
Audiojoe Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Oh THAT close button!! I thought you meant you'd drawn one on there and didn't want people pressing it. I thought that was a bit strange....