Ricky,

If you are in XL97, have a look at using application.statusbar in the help
file. If you are in xl2000 or higher, create a custom userform with only a
label on it that says "Macro running..." and show it as modeless.

In your code
My Sub()
frmWait.show(vbmodeless)
'run code here
unload frmWait
End Sub

Alternatively, for a more elegant solution there is a progress bar class on
my site (which does the same thing but with progress indicators) at
http://www.enhanceddatasystems.com/E...rogressBar.htm. If you use
it, for your purposes, just remove the Cancel button and related code for
the form.

Yours,

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"Ricky Pang" wrote in message
...
Hello Experts,
I have a macro that's rather long. In order to run it faster, I turned
off the screenupdating. But, if another user activates the macro,
nothing happens on-screen so they attempt to click on the macro button a
few more times. That interrupts the macro which is running in the
background.

How do you write an on-screen message in code that says "Please wait
While the Macro is Running"? And how do you take it off? I would take
the msg off just after I turn the screenupdating back On.

I'm looking for a msg box only without the "OK" button.

Thanks in advance,
Ricky

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!