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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.