PDA

View Full Version : Form Exit Button



Mike Vance
10-30-2007, 05:47 AM
I need to either disable or hide the form exit button.
I am using VBA with Rockwell RSview32.
Stuck on this issue for awhile. Very much appreciate any help.

Thanks,

Bob Phillips
10-30-2007, 10:49 AM
Which form exit button are you referring to?

Mike Vance
10-30-2007, 11:34 AM
I need to either disable or hide the form exit button.
I am using VBA with Rockwell RSview32.
Stuck on this issue for awhile. Very much appreciate any help.

Thanks,

Mike Vance
10-30-2007, 11:35 AM
The Default "X" next to the minimize and maximize buttons.

Thanks,

lucas
10-30-2007, 11:47 AM
On a userform Mike?

lucas
10-30-2007, 11:51 AM
This works on a userform in Excel...
put it in the userform code module:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then
Cancel = True
MsgBox "The X is disabled, please use the Close Command Button.", vbCritical
End If

End Sub

lucas
10-30-2007, 12:02 PM
Mike,
I deleted your post in the other forum.....please do not post duplicate questions in multiple forums. It will only cause the good folks here to avoid your posts completely.....

Please be considerate of the people who visit here to help others out. Surely you can see why it would be very annoying to go to the effort to find a solution for you only to find out that it had already been answered.....

Mike Vance
10-30-2007, 12:55 PM
Worked!

Thank you,