Adding a password to a splase screen???


Posted by angelo on November 01, 2000 4:20 AM

i have created a splash screen in my workbook. What i like
to do is after the user closed the splash screen.a dialog
box will appear and asking for password.if they don't know the
password.they can't open the workbook.thanks hope
you guys can help me

Posted by John Rigali on November 01, 2000 8:40 AM

Re: Adding a password to a splash screen???

Must the password prompt appear AFTER the splash screen? If you protect the workbook with a password, Excel should prompt for its password when it's being opened, before the splash screen appears.

Posted by angelo on November 01, 2000 9:17 AM

yes..mr John.. i want the password appear after the splash screen and not before the splash screen.can someone teach me or write down some kind of code.thanks

Posted by Tim Francis-Wright on November 01, 2000 9:31 AM

Re: Adding a password to a splash screen???

Would it be possible to have one workbook display
the splash screen, then open a second (protected)
notebook?

Posted by angelo on November 02, 2000 3:26 AM

What do you mean by that Tim.I can't understand

Posted by John Rigali on November 02, 2000 11:36 PM

what Tim means is...

...to have a first workbook that contains only the splash screen and some kind of trigger (maybe a macro assigned to a button) to open another workbook that is protected by a password and contains your worksheet(s). Very clever!



Posted by John Rigali on November 06, 2000 7:56 AM

well then...

Use Tim's solution which is the 3rd reply above. I explain this solution above.