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
|