Restrict access to certain sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
I do this all the time. Don't protect the Workbook, just each
Worksheet then:
1. make all the cells Protection Format Hidden and Locked
2. Format the Font of all the cells to be the same color as the
background.
3. Conditional Format all the cells with the formula =ISTEXT($A$2)
and format the Font to be the same color as the background.
4. Hide all the columns you use and put your used cells into columns
to the right of AA and in rows 100 and below.
5. Hide the worksheet.
6. Create several other similar Worksheets and Hide them.
An occasional snooper, after cracking your password, will never wade
through all that, particularly if he doesn't know there is a Worksheet
that is hidden.

Another possibility is to put the private worksheet in a different
Workbook unavailable to the others.


ed
 
Back
Top