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

[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.

(e-mail address removed) or
(e-mail address removed)

 

[izel brant]

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.
(e-mail address removed)
(e-mail address removed)

Regards

"Sreeraman Thillaisthanam Seshadri":