Forum Discussion
Excel file won't be opened while macro is running.
I have a long-running macro, which takes from several minutes to even an hour for executing. I found that while the macro is running, the excel file cannot be opened. All the excel files will only ...
Thanks, this indeed make the file open once I embed this function as a button in my userform.
However, I would expect this problem be solved by the application itself. Not to compromise it with VBA codes...
However, I would expect this problem be solved by the application itself. Not to compromise it with VBA codes...
I'm afraid it doesn't work that way...