Forum Discussion
Unexpected VBA Behavior: Userform showModal=False & close other Excel files make userform closed
I found that when setting the UserForm with `showModal=False` and close other excel file (not the one contains macro) will make UserForm disappear, too.... I have a long-running macro that user migh...
HansVogelaar
You really know them well XDDD
Just in case that they won't solve it, is there anything I can do to solve this issue?
The only one that I can figured out is to disable the close event until the macro finishes it work....
Do you really need the userform to be modeless? If so, I don't know of a better workaround...
HansVogelaar
I believe that being modeless is a must.All my users are heavy excel users. It is nearly impossible to ask them not to use excel while running the macro.
Thanks a lot for help!