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!

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

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