Hide title bar in User Form

TheNoocH

Well-known Member
Joined
Oct 6, 2004
Messages
3,482
i currently use the following code to disable the close button (ie the "X") on user forms...but i was curious is there anyway to hide the title bar?


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

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,114,446
Messages
5,547,967
Members
410,820
Latest member
Prepost
Top