Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
Short question: Is it possible to display an userform without it's titlebar? And if the answer ist 'yes', how can I do this? Thanks Michi |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Michi
Place this into the userform code: Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _ (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function GetWindowLong Lib "user32" Alias _ "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" _ (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long Private Declare Function DrawMenuBar Lib "user32" (ByVal hWnd As Long) As Long Private Sub UserForm_Initialize() Dim hWnd As Long, Style As Long hWnd = FindWindow(vbNullString, Me.Caption) Style = GetWindowLong(hWnd, -16) And Not &HC00000 SetWindowLong hWnd, -16, Style DrawMenuBar hWnd End Sub HTH Cordially Pascal "Michael Mueller" a écrit dans le message de news: ... Hi. Short question: Is it possible to display an userform without it's titlebar? And if the answer ist 'yes', how can I do this? Thanks Michi |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to display an userform without it's titlebar?
Place this into the userform code: Thanks Michi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is [Group] in the titlebar of an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Full Pathname in Titlebar | Setting up and Configuration of Excel | |||
Userform Titlebar Color | Excel Programming | |||
Form titlebar height | Excel Programming | |||
userform titlebar and closing form | Excel Programming |