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.
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
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?
What do you mean by that Tim.I can't understand
...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!
Use Tim's solution which is the 3rd reply above. I explain this solution above.