Admin Password for multiple workbooks

Hi,

I'm creating multiple workbooks in excel for designated persons, and they are suppose to look at them, each having a different password for security reasons. Now, is there any way to also create an administrator password, so that with only one password i would have access to all workbooks?

That way everyone will have its own password without knowing the other's, and one person will be able to access all workbooks with only one password.

Thank you.

Richard

That's not the way excel's password works.

But you could give the admin a workbook that has some sort of menu system in it
that opens a selected file--and supplies the password for that file. (So each
file could have its own password--but the admin only needs to know the password
of the "master" workbook.)



richard pabey wrote:
>
> Hi,
>
> I'm creating multiple workbooks in excel for designated persons, and
> they are suppose to look at them, each having a different password for
> security reasons. Now, is there any way to also create an administrator
> password, so that with only one password i would have access to all
> workbooks?
>
> That way everyone will have its own password without knowing the
> other's, and one person will be able to access all workbooks with only
> one password.
>
> Thank you.
>
> Richard
>
> --
> richard pabey
> ------------------------------------------------------------------------
> richard pabey's Profile: http://www.excelforum.com/member.php...o&userid=37234
> View this thread: http://www.excelforum.com/showthread...hreadid=569452

--

Dave Peterson