View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default 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