Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
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
Re: Adding a password to a splash screen???
Posted by John Rigali on November 01, 2000 8:40 AM
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.
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 angelo on November 01, 2000 9:17 AM
Re: Adding a password to a splash screen???
Posted by Tim Francis-Wright on November 01, 2000 9:31 AM
Would it be possible to have one workbook display
the splash screen, then open a second (protected)
notebook?
What do you mean by that Tim.I can't understand
Posted by angelo on November 02, 2000 3:26 AM
what Tim means is...
Posted by John Rigali on November 02, 2000 11:36 PM
...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!
well then...
Posted by John Rigali on November 06, 2000 7:56 AM
Use Tim's solution which is the 3rd reply above. I explain this solution above.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.