Make Excel particular sheet protection on net

Closed
Deep - Aug 25, 2009 at 02:39 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 27, 2009 at 09:46 AM
Hello,

I have Excel sheet, with containing around 10 sheets, tat sheer was shared in net work with 5 diffrrent persons (systems). each person is responsible for add data's for particular 2 sheet. tat person should not edit or access remaining sheet. Make more clear Eg : I am deep working in Sheet 1 and 2 , I should not edit the data's or formulas in remaining sheets (3,4,....10). same way another person ganesh is working on sheet no 3 and 4, he should have access editing authorization for remaining sheet (i.e sheet 1,2,5,6...10). Like.. But keep it mind this Excel work book is shared common net work

Please Help Me with my problem...


Thanks in advance


Deep
Related:

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 27, 2009 at 09:46 AM
Password protect the individual sheets with different passwords but all sheets for a particula r user should be the same. and inform the password to you and that particular person
1