I am having a similar problem here. I created a long running macro, and
would like the user to be able to navigate around the workbook while the
macro is running. In the mean time, I popup a modeless dialog to keep the
user inform regarding the process. I face two problems:

1. Excel stop responding to input while the macro is running. I can't
navigate the workbook.
2. My modeless dialog box doesn't repaint until the macro is done.

Both problem originate from which Excel did not handle window messages while
the macro is running. I tried to peek into the message loop to process the
message, but that doesn't help either.

Anybody has a solution to this?


James.