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