userform close when i close another excel file

[azizls4]

hello
I have UserForm, when I open another Excel file and then close it, UserForm closes automatically. Is there a code I add to UserForm that prevents it from being closed when I close another Excel file?
thank you

 

[Herakles]

hello
I have UserForm, when I open another Excel file and then close it, UserForm closes automatically. Is there a code I add to UserForm that prevents it from being closed when I close another Excel file?
thank you

Does setting the ShowModal form property to False work?

 

[azizls4]

Does setting the ShowModal form property to False work?

When UserForm works, it hides its Excel file, only UserForm is in the interface, but when I open another Excel file and close it, UserForm also closes

 

[Herakles]

When UserForm works, it hides its Excel file, only UserForm is in the interface, but when I open another Excel file and close it, UserForm also closes

What does this mean?

only UserForm is in the interface

Do you activate the workbook containing the Userform before closing the other workbook?

 

[azizls4]

What does this mean?

only UserForm is in the interface

Do you activate the workbook containing the Userform before closing the other workbook?

yes userform is active

 

[Herakles]

yes userform is active

Do you activate the workbook containing the Userform before closing the other workbook?

 

[azizls4]

Do you activate the workbook containing the Userform before closing the other workbook?

no i didnt

 

[Jaafar Tribak]

Are you using Excel 2016?
If you close the new workbook from the File | Close menu, the problem doesn't happen. The problem only happens when you close the workbook from the excel main titlebar X close button.
I think this is a bug in excel 2016 and has nothing to do with the userform... I think if you update to the latest version of Office, this issue should be fixed.

 

[Herakles]

What happens when you manage the opening and closing of workbooks from the Userform?

 

[azizls4]

Are you using Excel 2016?
If you close the new workbook from the File | Close menu, the problem doesn't happen. The problem only happens when you close the workbook from the excel main titlebar X close button.
I think this is a bug in excel 2016 and has nothing to do with the userform... I think if you update to the latest version of Office, this issue should be fixed.

Yes, I use Excel 2016, and I tried to make a showmodal in the properties True and Fulse, but it did not work