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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,114,086
Messages
5,545,878
Members
410,711
Latest member
Josh324
Top