thanks so would having a button on userform 1 that calls a module that
first unloads form1 then opens form2 would be ok
ie.

Private Sub CommandButton6_Click()
Call finnish
End Sub


sub finnish ()

unload userfrom1

various lines of code


userfrom2.show

end sub