I am using Office 2003 on Windows XP.

I have created a form in a sheet that many users will open and complete.
Completion of the form and validation are dependent upon several macros so I
am trying to code a splash screen that is in view when the file opens and
only if macros are enabled will the splash screen go away and the form will
become visible.

The problem comes in when the user closes the file. The splash screen must
be brought back into view and the form hidden. I am having difficulty coding
this so it will run properly. At first, on shut down, I got a recursive
message (twice), so I changed some of my code, then it wouldn't let me out at
all, so I changed some more and now my On_Open event won't fire so it is
stuck on the splash screen.

1) Can someone please help me out here with specific example code so I can
make this thing run?

2) I guess there is no way to allow the user to close the file without
saving changes, since it must always be saved with the splash screen visible?

3) Since my code is, at this point, rather convoluted I won't post it,
please just use generic names in the example.

THANKS MUCH FOR YOUR ASSISTANCE!

I think I've cracked it. I was "over" coding.
No need for replies. Thanks for reading.

"quartz" wrote:

I am using Office 2003 on Windows XP.

I have created a form in a sheet that many users will open and complete.
Completion of the form and validation are dependent upon several macros so I
am trying to code a splash screen that is in view when the file opens and
only if macros are enabled will the splash screen go away and the form will
become visible.

The problem comes in when the user closes the file. The splash screen must
be brought back into view and the form hidden. I am having difficulty coding
this so it will run properly. At first, on shut down, I got a recursive
message (twice), so I changed some of my code, then it wouldn't let me out at
all, so I changed some more and now my On_Open event won't fire so it is
stuck on the splash screen.

1) Can someone please help me out here with specific example code so I can
make this thing run?

2) I guess there is no way to allow the user to close the file without
saving changes, since it must always be saved with the splash screen visible?

3) Since my code is, at this point, rather convoluted I won't post it,
please just use generic names in the example.

THANKS MUCH FOR YOUR ASSISTANCE!