Hi Michelle,
I'm not exactly sure what you're trying for here, but I would:
1. Create a macro that saves the file.
2. Then edit the macro and add a Userform that will be your splashscreen.
3. I would probably put all this on a toolbar button so when the user clicks
the button it saves and displays the screen.
If you need more info on the Userform, let me know.
Jill E