I managers that have teams. I use a workbook to track any errors that a
managers team memeber makes. I need to open just those that are assigned to
a particular manager. I don't want managers looking at other managers errors.
So if I set it up so that they creat a log in ( or I assign one) and
password it would accommplish my task.

"Gord Dibben" wrote:

The question "why do you need multiple passwords to open the workbook?" comes to
mind if users are opening just the single workbook.

Back to the question "How do I set up multiple log ins and passwords for this
workbook?"

You could have them first open a dummy workbook with select case code to trap
their login name and ask for a password that matches that name.

If correct password entered, the workbook would open.

There may be another method depending upon why you want this.

Do you want to deny access to some users?

Do you want the workbook to open with just certain sheets visible depending upon
which user opens the workbook?


Gord

On Tue, 24 Jul 2007 09:54:02 -0700, David A.
wrote:
How do I set up multible log ins and passwrods for this workbook?


"Gord Dibben" wrote:

No such thing as a Master password that overrides individual passwords

Keep a list of the users' passwords handy so's you can assist when they forget.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 09:02:01 -0700, David A.
wrote:

I need to let the user chose thier own password. Of course I will need a
master password for my self to reset anyone that forgets theirs. Is there a
way to do this?