K
King
Hi,
I am running an excel macro that fatches data from the database and
generats excel reports on multiple sheets. This process sometimes takes
about an hour or two. But during this retrieve process, users are not
able to open a new excel workbook, or they can not even open
aready-opened excel workbooks. Users can not minimize the excel
workbook where the process is going on, and can not even switch the
already open excel workbooks.
Is there anything I should set in the code to allow users to switch the
workbook?
Thanks in advance.
I am running an excel macro that fatches data from the database and
generats excel reports on multiple sheets. This process sometimes takes
about an hour or two. But during this retrieve process, users are not
able to open a new excel workbook, or they can not even open
aready-opened excel workbooks. Users can not minimize the excel
workbook where the process is going on, and can not even switch the
already open excel workbooks.
Is there anything I should set in the code to allow users to switch the
workbook?
Thanks in advance.