Now that you mention it, I probably can only use 1 password to open the
workbook. Would the be a way to have the user have to type in a password on
the open event, and then pass this as a public variable that could then be
used?

"Gord Dibben" wrote:

How do you set more than one password to open a workbook?

Or do you mean password after opening?

Like a password to access a certain sheet in the workbook?


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 14:12:02 -0700, DogLover
wrote:

I would like to set a variable to be 1 of 7 values based on what password is
used to open a spreadsheet. Does any know if this is possible?? If so,
please provide some helpful hints.

Thanks for your help.

.