How to define separate Password Protection, to say 3 persons, for.
 

How to define separate Password Protection, to say 3 persons, for few columns
each, in same file.

In an excel file: say with 20 columns of data: column A to G is entered &
maintained by Person 'A'
Another person 'B' enters & uses data in rest of columns form H onwards.
The total data in column A to T is used both by Person "A" as well as Person
"B"- for making reports: selecting data of one another.
I need to assign separate password rights to Person A & B and €œread only€� to
any one else wanting to browse the data.
HOW DO I DO THIS: Can any one help tell me if it is possible OR NOT.

The version of excel I use is: Excel 2000.

or

Dear Sirs ,

I am looking the answer of the same question.
For now I could not solve it but in excel Xp there is a command "protection/
allow user to arrange and modify the cells.
when I choose that option and try to lock the cells seperatly for each
person I can only see my computer name . If I can find the other names in
someway I think I will be able to solve the problem.
By the way , if you have know the answer please contact me.



Regards

"Sreeraman Thillaisthanam Seshadri":

How to define separate Password Protection, to say 3 persons, for few columns
each, in same file.

In an excel file: say with 20 columns of data: column A to G is entered &
maintained by Person 'A'
Another person 'B' enters & uses data in rest of columns form H onwards.
The total data in column A to T is used both by Person "A" as well as Person
"B"- for making reports: selecting data of one another.
I need to assign separate password rights to Person A & B and €œread only€� to
any one else wanting to browse the data.
HOW DO I DO THIS: Can any one help tell me if it is possible OR NOT.

The version of excel I use is: Excel 2000.

or