I have a workbook that has multiple worksheets that are created and maintained by different people. I want the worksheets password protected so that only certain people can access them. Also I need for one person to access all worksheets.
I've found how to password protect the entire workbook and how to protect individual cells in worksheets but not how to password protect individual worksheets
How do I do that for Excel 2013. Also these machines are in a Workgroup not a Domain, if that makes any difference