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.
You have a response to your first post.
Matt wrote:
gt;
gt; I have a workbook that is made up of sheets for each salesperson. The boss
gt; wants them to be able to open the workbook and edit their sheet ONLY. On top
gt; of that, each salesperson would only be able to SEE their own sheet (all
gt; others would be hidden from them) but when Admin opens the workbook, THEY can
gt; immediately see ALL the salespeople's sheets.
gt;
gt; Is this even possible? Thanks.
--
Dave Peterson
- Sep 10 Mon 2007 20:39
worksheet protection
close
全站熱搜
留言列表
發表留言