User form Freeze

[0meg@]

Need to show one form by clicking the button and hide parent form. Also i didn't find how to make form not moveable by user.

[shelbym]

You just need to hide the current form and show your second form like this:

Me.Hide
UserForm2.Show

If you want to make the form unmovable you can use a few API calls to make this work. Something like this:

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetSystemMenu Lib "user32" (ByVal hWnd As Long, ByVal bRevert As Long) As Long
Private Declare Function RemoveMenu Lib "user32" (ByVal hMenu As Long, ByVal nPosition As Long, ByVal wFlags As Long) As Long
Private Declare Function FindWindowA Lib "user32" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
  
Private Const MF_BYPOSITION As Long = &H400

Private Sub UserForm_Initialize()
    Dim lFrmHdl As Long, iCount As Integer
    
    lFrmHdl = FindWindowA(vbNullString, Me.Caption)

    If lFrmHdl <> 0 Then
        For iCount = 0 To 2
            RemoveMenu GetSystemMenu(lFrmHdl, False), 0, MF_BYPOSITION
        Next iCount
    End If
End Sub

Hope that gets you started,

-Shelby