I just read this question which someone posted this a few days ago, but didn't get any responses. I am very interested in the answer if there is one, so I'm posting it again.

Is it possible to run a macro in the "background" so that you can keep editing the file while the macro runs? - assuming of course that the cells you are editing are not affected by the macro.

Cheers
free