Multiple user password

[Pmcn]

I am using Excel 2000. I am trying to create a work sheet that allows
multiple users to modify different cells with different passwords.

EXAMPLE:

Mike can only modify column 1 with his password and the rest is read only.
Joe can only modify column 2 with his password ect...............

Thanks!

[jtp]

Hi PMCN,
Assuming you do know how to build the login portion for each user, I would set it up by locking cells and setting protection based on each user. For instance, if Mike opens the workbook, after verifying his login/password:

1. Make sure all the cells are locked in that sheet
Worksheet("Yoursheet").Cells.Locked = True

2. Unlock the cells in column A.
Columns("A:A").Locked = False 'For Mike

3. Then protect the worksheet with your own password.
ActiveSheet.Protect Password:="Your Password", DrawingObjects:=True, Contents:=True, Scenarios:=True

This will allow Mike to only update Column A cells. Do the same for all the other logins. Setting up the login/password stuff is a bit more complex.


I am using Excel 2000. I am trying to create a work sheet that allows
multiple users to modify different cells with different passwords.

EXAMPLE:

Mike can only modify column 1 with his password and the rest is read only.
Joe can only modify column 2 with his password ect...............

Thanks!

[Pmcn]

Jtp,
Thanks for your help.

Let's assume I know nothing about how to build login portion. Where can I
find this info?

Thanks again

"jtp" wrote:

>
> Hi PMCN,
> Assuming you do know how to build the login portion for each user, I
> would set it up by locking cells and setting protection based on each
> user. For instance, if Mike opens the workbook, after verifying his
> login/password:
>
> 1. Make sure all the cells are locked in that sheet
> -Worksheet("Yoursheet").Cells.Locked = True-
>
> 2. Unlock the cells in column A.
> -Columns("A:A").Locked = False 'For Mike-
>
> 3. Then protect the worksheet with your own password.
> -ActiveSheet.Protect Password:="Your Password", DrawingObjects:=True,
> Contents:=True, Scenarios:=True-
>
> This will allow Mike to only update Column A cells. Do the same for
> all the other logins. Setting up the login/password stuff is a bit
> more complex.
>
>
> I am using Excel 2000. I am trying to create a work sheet that allows
> multiple users to modify different cells with different passwords.
>
> EXAMPLE:
>
> Mike can only modify column 1 with his password and the rest is read
> only.
> Joe can only modify column 2 with his password ect...............
>
> Thanks!
>
>
> --
> jtp
> ------------------------------------------------------------------------
> jtp's Profile: http://www.excelforum.com/member.php...o&userid=21132
> View this thread: http://www.excelforum.com/showthread...hreadid=495840
>
>