View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
jamieuk jamieuk is offline
external usenet poster
 
Posts: 8
Default Macro freezes Excel

You can create a worker thread in VBA using APIs? I've only seen this
done using MFCs in C++. Please post some exmaple code.

--

"mb" wrote in message ...
Yes and No.
Yes: You can use the Win32 API to create a worker thread.


"Yohan" wrote in message
...


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?