"weisenb_stev" wrote in message
...
I am currently writing VBA code to refresh and update an Excel Workbook
with
many queries and pivot tables - thus, it takes a few minutes.

Does anyone know if a Message Box can be displayed telling the user that
the
Macro is running, and then automatically diasappear after it closes???


You could use a progress bar. See
http://www.enhanceddatasystems.com/E...rogressBar.htm


Also, I've heard of "Splash Screens" but cannot find any information in
the
VBA Help, Microsoft Office Online, or in my VBA books. Does anyone know
anything about these?


See http://xldynamic.com/source/xld.xlFAQ0007.html