Locking a userform position

[elgringo56]

I have a userform that I would like to lock in position. As it is now, if the user "grabs" the top blue bar on the userform, he can move it around, and I would like to prevent that. Is this possible?

 

[elgringo56]

Interesting, I did a loop count 0 to 6 and it does dim the close button, which is pretty good, I guess. Would like it to be gone altogether, though, if there is a way.

 

[Sayth]

Sorry figured it out.

 

[Cscott0685]

I know this is an old thread, but here's how I was able to "lock" the userform position, quick and easy.

Private Sub UserForm_Layout()
    
    If UserForm_Main.Left <> -8 Or UserForm_Main.Top <> 0 Then       'Checks to see if current position matches the presets I defined
        
        MsgBox "Cannot Move Screen.", vbCritical
    
        With UserForm_Main      'Moves userform back to original positions (this eliminates the "duplicate" error for vertical and/or horizontal movement)
            .Left = -8
            .Top = 0
        End With
    
    End If
    
End Sub

 

[Steve001]

Hi All,

I am trying to lock a user form onto a tab "Menu" the code above can i ask where do i put this ? as i don't seam to be able to get it to work

i have tried on the tab "Menu", on the user form
Can somebody please explain to me please

Can you please put comments in any code - still finding my feet in VBA

Steve