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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,868
Members
409,842
Latest member
mfernandezcean
Top