View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nan Nan is offline
external usenet poster
 
Posts: 23
Default Message while macro is executing

My macro takes several seconds to execute. I'd like some sort of message to
pop up and distract users from the flickering screen in the background while
the macro runs. Is there a way to display a blank screen, or at least ask
users to be patient, while the continues to run? I put in a message box, but
the macro stops until the user clicks "OK".

I appreciate any suggestions and thank you for taking time to help
--
TIA, Nan