Message Window to tell user "Macro Running"
 

Does anyone know where I can find a bit of code to display
a window that reads: Macro Running, Please Wait or
something like that?

Message Window to tell user "Macro Running"
 

Application.StatusBar = "Macro Running, Please Wait or
something like that?"

-----Original Message-----
Does anyone know where I can find a bit of code to
display
a window that reads: Macro Running, Please Wait or
something like that?
.

Message Window to tell user "Macro Running"
 

careful though, error trapping is needed, if the macro throws an error
before it gets to application.statusbar = false, because the user will
be left with "Macro Running, Please Wait" whenthey exit the workbook!

"Jack" wrote in message ...
Application.StatusBar = "Macro Running, Please Wait or
something like that?"

-----Original Message-----
Does anyone know where I can find a bit of code to
display
a window that reads: Macro Running, Please Wait or
something like that?
.