I have a workbook with several tabs. Each tab is password protected to avoid supervisors from editing any cell they are not allowed to. I'd also like to protect the other tabs from being viewed by other supervisors so this can be a shared workbook. Is this possible?
Edit:
Sorry, need to add a little more explanation. I have a Manager tab that is a summary tab of all of their supervisors, which have their own tab. Each tab has data that the supervisor needs to enter information on but because of the formulas, they only have access to certain cells in their sheet. Since there are other supervisors, the manager does not want them to see the data entered by other supervisors, so I need to make it where the supervisor can only see his/her tab as well as keep the current cells locked. Thanks
Edit:
Sorry, need to add a little more explanation. I have a Manager tab that is a summary tab of all of their supervisors, which have their own tab. Each tab has data that the supervisor needs to enter information on but because of the formulas, they only have access to certain cells in their sheet. Since there are other supervisors, the manager does not want them to see the data entered by other supervisors, so I need to make it where the supervisor can only see his/her tab as well as keep the current cells locked. Thanks
Last edited by a moderator: