Q: User form closes when a different workbook is closed Kindly assist on the code that I can use to prevent different closing workbook affecting a user forms of another workbook from closing. I have three user forms. Userform1, Userform2 and userform3. I want all these user forms not to be affected by closing the workbook. This is the code I am using:
Sub Auto_Close()
    If This Workbook.Saved = False Then
        This Workbook.Save
    End If
End Sub


A: I'll post this as the answer with a picture for you to reference. Your userform should be in the project that stays open. The picture spells it out pretty clearly.

If your issue persists, make your userform modeless. You can do this by adding this: UserForm1.Show vbModeless. Or you can set your userform property ShowModal = False.
