Protecting Workbook to prevent certain sheets from being visible to unauthorized

Copper Contributor

I have a workbook that contains client information for several members of a team. I want only the specific team member to have access to their sheet in the workbook while the team leader has access to all the sheets. I do not want the other members to even be able to see the other sheets. Is there a way to do this without creating multiple workbooks and sheets.

0 Replies