Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Re Newbie,
Or if you prefer (to envisage a button to close the userform): Private Declare Function FindWindowA& Lib "User32" _ (ByVal lpClassName$, ByVal lpWindowName$) Private Declare Function SetWindowLongA& Lib "User32" _ (ByVal hWnd&, ByVal nIndex&, ByVal dwNewLong&) ' Necessary button to close userform Private Sub CommandButton1_Click() Unload Me End Sub Private Sub UserForm_Initialize() Me.StartUpPosition = 0 Me.Left = 50: Me.Top = 90 Dim hWnd As Long, exLong As Long hWnd = FindWindowA(vbNullString, Me.Caption) SetWindowLongA hWnd, -16, &H84400080 End Sub MP "Newbie" a écrit dans le message de ... Is it possible to lock the position of a userform to prevent users from dragging it around the screen? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserForm position | Excel Discussion (Misc queries) | |||
How can I lock the position of a textbox? | Excel Discussion (Misc queries) | |||
Userform Position | Excel Programming | |||
freeze/lock form position | Excel Programming | |||
UserForm position | Excel Programming |