Hi Bob,

Don't think that this will work, as the technique needs some interrupt
points to update the bar,

I should have read more closely.

Thank you for the correction.

---
Regards,
Norman



"Bob Phillips" wrote in message
...
Don't think that this will work, as the technique needs some interrupt
points to update the bar, whereas there will only be one in this
instances,
when it has finished. I think you need some sort of asynchronous bar,
which
would probably mean that it is not a true state of progress, rather a
visual
indicator.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Jones" wrote in message
...
Hi Johny5,

See John Walkenbach's web site for the follqwing suggestion:


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


---
Regards,
Norman



wrote in message
oups.com...
hi,

I have a macro that opens up a word document thats sits on a server,
the document takes a while to open, and it does seem that the program
has stalled until the doc appears, is there anything that i can display
on screen like a userform/progress bar that keeps going/loading until
the doc appears

thanks you clever lot

Johny5