ExcelBanter - Close Buttom

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Close Buttom (https://www.excelbanter.com/excel-programming/400516-close-buttom.html)

alvin Kuiper

Close Buttom

Hi
In a userform there are a Red Cross to close the form
Can i disable this ?

Regards
alvin

GerardV

Close Buttom

I use the userform queryclose to disable 'Red Cross'

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
End If
End Sub

--
-----------------------------

"alvin Kuiper" wrote:

Hi
In a userform there are a Red Cross to close the form
Can i disable this ?

Regards
alvin

alvin Kuiper

Close Buttom

Thanks
Alvin

"GerardV" skrev:

I use the userform queryclose to disable 'Red Cross'

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = vbFormControlMenu Then
Cancel = True
End If
End Sub

--
-----------------------------

"alvin Kuiper" wrote:

Hi
In a userform there are a Red Cross to close the form
Can i disable this ?

Regards
alvin

All times are GMT +1. The time now is 07:14 AM.