hide and protect worksheets

  • Thread starter Thread starter JimO
  • Start date Start date
J

JimO

We want to create a single workbook, consisting of
worksheets (one per person). The last worksheet will be a
summation of all the people's data. So, if on Sheet1,
Cell A2 might be phone calls made. We would then on Sheet
9 have a sum of sheet1 through sheet 8 placed in Cell A2.
That is not the problem. I need to find a way to hide
individual sheets and protect them so others cannot view
sheets that do not belong to them. Is there a way to do
this?
 
Jim,

Sheets can be hidden (Format - Sheets - Hide). The summary sheet will still
work. Then the workbook (not worksheet) can be protected with Format -
Protection - Workbook, to keep folks from unhiding sheets. You can use a
password to keep folks from unprotecting the workbook.
 
That works just as I had hoped. Thanks for the help, Earl!
-----Original Message-----
Jim,

Sheets can be hidden (Format - Sheets - Hide). The
Click to expand...
summary sheet will still >work. Then the workbook (not
worksheet) can be protected with Format - >Protection -
Workbook, to keep folks from unhiding sheets. You can
use a >password to keep folks from unprotecting the
workbook.be a >> summation of all the people's data. So, if on
Sheet1, >> Cell A2 might be phone calls made. We would
then on Sheet >> 9 have a sum of sheet1 through sheet 8
placed in Cell A2. >> That is not the problem. I need to
find a way to hide >> individual sheets and protect them
so others cannot view >> sheets that do not belong to
them. Is there a way to do >> this?
 
Back
Top