Nuz
06-22-2011, 10:06 PM
I have VBA code that imports external data to workbook and saves the workbook multiple times during the process. Since it is a lengthy process, I use a progress bar to show the progress of the process to user.
I have a separate userform that has the progress bar etc. stuff but the problem is that the form sometimes disappears (when the workbook is saved), and the user cannot move it because the form is not responding.
I already use the routine to bring the form to the front of other modeless forms but it still disappeares multiple times during the process.
Is there any way to make the progress bar stable even on saving the workbook, something like Windows has when multiple files are copied from one directory to another.
I have a separate userform that has the progress bar etc. stuff but the problem is that the form sometimes disappears (when the workbook is saved), and the user cannot move it because the form is not responding.
I already use the routine to bring the form to the front of other modeless forms but it still disappeares multiple times during the process.
Is there any way to make the progress bar stable even on saving the workbook, something like Windows has when multiple files are copied from one directory to another.