Hide title bar in User Form

[TheNoocH]

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?

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

 

[erik.van.geit]

Hi,

perhaps this ?
http://www.mrexcel.com/board2/viewtopic.php?t=47416

kind regards,
Erik

 

[TheNoocH]

Erik,
thanks for your help....that worked as intended...