How to run a process in the background?

[yajiv.vijay]

I have a macro which will create sheets and update its contents.
I have used
applicaiton.screenupdating=false
to have a background process. I still want to update the user whats
happening behind. Perhaps with a progress bar. Is it possible to have
control on one sheet and have the macro running on the background?

 

[karma]

I have a macro which will create sheets and update its contents.
I have used
applicaiton.screenupdating=false
to have a background process. I still want to update the user whats
happening behind. Perhaps with a progress bar. Is it possible to have
control on one sheet and have the macro running on the background?

Yes, you can display a progress bar while the macro is running. It
does however require you to create a form and you will need to add a
bit of extra code.
You may find this link useful

http://j-walk.com/ss/Excel/tips/tip34.htm

HTH