worksheet protection

[Matt]

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]

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