PDA

View Full Version : how to protect shared worksheet



erickham
2015-11-10, 07:23 PM
I have created an excel sheet which was shared among multiple users who need to edit an assigned column with password protection so that other could not modify their entry. the idea is that each person will have to enter his password to unprotected/protect an assigned column in the shared sheet. But after sharing the sheet, protect sheet option under Review became inactive making it difficult to unprotected the column and edict it. What should I do? Please help! Thanks!