#1   Report Post  
Posted to microsoft.public.excel.misc
Matt
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet protection yemi Excel Discussion (Misc queries) 3 May 20th 05 10:12 PM
Worksheet tab protection Xlim Excel Discussion (Misc queries) 2 January 16th 05 01:34 PM
Worksheet tab protection Xieng Lim Excel Discussion (Misc queries) 0 January 16th 05 04:03 AM
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 03:07 PM
Seeking help for total worksheet protection Joseph Geretz Excel Discussion (Misc queries) 10 December 31st 04 06:48 PM


All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"