More than one password?

Is it possible to protect a sheet with a master password and still let
someone create their own password?

I would like to create individual workbooks for members were they can create
their own password, yet I would still like to access them all with one master
password. Is this possible?

You say sheet, then talk about workbooks, but regardless:

Not using built in methods.




--
Regards,
Tom Ogilvy


"Tim" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to protect a sheet with a master password and still let
> someone create their own password?
>
> I would like to create individual workbooks for members were they can
create
> their own password, yet I would still like to access them all with one
master
> password. Is this possible?

Thanks, Tom.
I did mean workbook.

"Tom Ogilvy" wrote:

> You say sheet, then talk about workbooks, but regardless:
>
> Not using built in methods.
>
>
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Tim" <[email protected]> wrote in message
> news:[email protected]...
> > Is it possible to protect a sheet with a master password and still let
> > someone create their own password?
> >
> > I would like to create individual workbooks for members were they can
> create
> > their own password, yet I would still like to access them all with one
> master
> > password. Is this possible?
>
>
>

Depends on what type of access, "YOU" need with 'so called' master password.

If access only to edit the cells is OK for you then it can work as under:
Click on Tools Menu -> Allow User to Edit Ranges
In the box that will appear click on 'New'.

In Refers to Cells: Filed enter " =1:65536 " (Without quotation marks!)
(This refers to entire workseet range).
Enter YOUR 'Master' password in the Range Password and click on OK.

Repeat this for all sheets if you wish.

Now the user can protect the sheet with his password.

when you want to edit a cell, click on it, it will prompt for Edit Range
Password,
enter it and you can edit (change) the cell.

Sharad

"Tim" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to protect a sheet with a master password and still let
> someone create their own password?
>
> I would like to create individual workbooks for members were they can
> create
> their own password, yet I would still like to access them all with one
> master
> password. Is this possible?

He clarified that he meant workbook, not worksheet passwords. You method is
for worksheets and then for worksheets in xl2002 and later, but he may find
it useful nonetheless.

--
Regards,
Tom Ogilvy




"Sharad Naik" <[email protected]> wrote in message
news:[email protected]...
> Depends on what type of access, "YOU" need with 'so called' master
password.
>
> If access only to edit the cells is OK for you then it can work as under:
> Click on Tools Menu -> Allow User to Edit Ranges
> In the box that will appear click on 'New'.
>
> In Refers to Cells: Filed enter " =1:65536 " (Without quotation marks!)
> (This refers to entire workseet range).
> Enter YOUR 'Master' password in the Range Password and click on OK.
>
> Repeat this for all sheets if you wish.
>
> Now the user can protect the sheet with his password.
>
> when you want to edit a cell, click on it, it will prompt for Edit Range
> Password,
> enter it and you can edit (change) the cell.
>
> Sharad
>
> "Tim" <[email protected]> wrote in message
> news:[email protected]...
> > Is it possible to protect a sheet with a master password and still let
> > someone create their own password?
> >
> > I would like to create individual workbooks for members were they can
> > create
> > their own password, yet I would still like to access them all with one
> > master
> > password. Is this possible?
>
>