Hi xlnitwit
Good to hear from you. My UserForm is not in the Workbook that gets opened. I'm not using Unload Me, so am confused. I changed code to the below with a call function and still closes userform...
Private Sub CommandButton5_Click()
Sheet4.Visible = True
Sheet4.Activate
Call InvNoGen
End Sub
Sub InvNoGen()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Workbooks.Open ("C:\Users\Steven\Desktop\fdp\no generator.xlsm")
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
Bookmarks