Restrict access to certain sheets
A quick solution may be hiding the columns/rows you don't want to be public,
and then protecting the sheet. Only the users who know the password will be
able to unhide the data.
Miguel.
"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
|