You have already asked this question 2 hours ago!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Yohan" wrote in message
...
Hi all!

I wrote some macros to interact and manipulate data in Access from Excel.
The macros works fine, but took quite a while to finish the calculation,
around 2-3 minutes, and while performing the calculation, Excel freezes.
If running that macro only once in a while is no problem.. but it's
starting to get irritating if everytime you run the macro, you need to wait
for 3 minutes before you can get back to the Excel file again.

My question is:
Is there any way to tell Excel to run the macro in the background so that
I can still work on my Excel file while Excel is doing the calculation?

Regards,
Yohan