Splash Screen upon save

[smithomatic]

Hello all, I was wandering if someone could tell me how to create a splash screen upon save. My Excel file is very large and saving takes about 20seconds, it looks very unproffessional when you have to sit looking at the loading egg timer for 20seconds.

Is it possible to have a splash screen appear whenever the file is saved?

If so, some step by step instructions on how to do this would be tremendous!

Thanks, i look forward to your comments.

 

[VoG]

Try this but use the BeforeSave event instead of Workbook_Open http://j-walk.com/ss/excel/tips/tip39.htm