Make Excel particular sheet protection on net

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!