View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Restrict access to certain sheets

Excel's protection isn't built for this. If a user can open the workbook, they
can see everything in that workbook--if they're dedicated snoopers.

Don't put anything into an excel workbook that you don't want to share with
others--or just don't share that workbook.

Jelinek wrote:

I have a workbook with 3 sheets 2 of the sheets are for general use but one
of the sheets i would like people to access only by a password is this
possible? i can protect the sheet but i would like only certain people to
view the information? protecting stops people from amending/entering data.

Thanks

Simon


--

Dave Peterson