ExcelBanter - worksheet protection

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - worksheet protection (https://www.excelbanter.com/excel-discussion-misc-queries/75180-worksheet-protection.html)

Matt

worksheet protection

I have a workbook that is made up of sheets for each salesperson. The boss
wants them to be able to open the workbook and edit their sheet ONLY. On top
of that, each salesperson would only be able to SEE their own sheet (all
others would be hidden from them) but when Admin opens the workbook, THEY can
immediately see ALL the salespeople's sheets.

Is this even possible? Thanks.

Dave Peterson

worksheet protection

You have a response to your first post.

Matt wrote:

I have a workbook that is made up of sheets for each salesperson. The boss
wants them to be able to open the workbook and edit their sheet ONLY. On top
of that, each salesperson would only be able to SEE their own sheet (all
others would be hidden from them) but when Admin opens the workbook, THEY can
immediately see ALL the salespeople's sheets.

Is this even possible? Thanks.

--

Dave Peterson

All times are GMT +1. The time now is 10:52 AM.