Prasad,

The easiest thing to do is create a custom form with this message, launch it
where you would currently fire the macro. In the form's initialize event,
call the macro there, which when it ends passes control back to the form,
where you can then unload it.

--

HTH

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


"BristolBloos" wrote in message
oups.com...
Hi,

I have got a user form that has some text boxes as well as some command
buttons.

I have got a macro which when running show not allow the user to do
anything on the screen.

Therefore I was wondering whether is it possible to show a message in
the middle of the screen in a grey window that says, for example,
"Uploading Details...". I don't want any buttons on this message
window. The only thing this should do is come up on the screen and
close when the running of the macro is completed.

Any suggestions please.

Thanks & Regards,
Prasad