Does setting the ShowModal form property to False work?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
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 closesDoes setting the ShowModal form property to False work?
What does this mean?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
yes userform is activeWhat does this mean?
only UserForm is in the interface
Do you activate the workbook containing the Userform before closing the other workbook?
Do you activate the workbook containing the Userform before closing the other workbook?yes userform is active
no i didntDo you activate the workbook containing the Userform before closing the other workbook?
Yes, I use Excel 2016, and I tried to make a showmodal in the properties True and Fulse, but it did not workAre 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.