msg box

[DD]

i would like my macro to display a message box, until the macro is
complete. i dont want to have the user click ok before the macro runs. is
there a way to do this.

thanks

 

[Ken Snell [MVP]]

Not a message box.... instead, create a form that contains a label with the
message you want to show as the caption of that label. Then have your macro
open that form as its first step (you'll want normal mode and normal view),
and then close that form as its last step.