Have a look here.
http://j-walk.com/ss/excel/tips/tip34.htm
Should be right up your alley for what you are after.

Corey....


wrote in message
ups.com...
I've got vba code that copies formulas into a range, calculates, then
copy/paste-values. Since there are lots of formulas, the calculation
takes 10 or 15 seconds, during which time the cursor shows an
hourglass. If the user just waits during this time, it works fine. But
if the user starts clicking around, the calculation doesn't work, and
the code finishes with bad values. It's as if the code changes the
formulas to values before the calculation is complete.

How do I make it so that the calculation is complete, regardless of
what the user does? One thing I'm thinking of is to have a pop up
message of "Please be patient..." or whatever to appear while the
calculation is going on. Would this help? Though I'm a skilled user of
vba, I have never done this specifically (having a pop up appear while
code runs in the background) and don't know how to do it.

Many thanks in advance.

Stuart
http://home.comcast.net/~sresnick2/mypage.htm