Having thought about it further, it really needs to be a UserForm because the
update part of the macro opens other workbooks and so when this happens the
text box will disappear as it's only linked to the sheet on the Master. Any
ideas??

Chris

"Markus Scheible" wrote:

Hi unknown,

maybe this is no answer to your question, but if you just
use the userform for displaying the alert while the macro
is working, just use a text box from shapes instead of the
userform, and you don't have all this trouble...

Best

Markus


-----Original Message-----
Message unavailable