Barb,

Not a very elegant solution but one that suits your needs without going down
the VBA route...

1. Hide the rows containg data on each persons sheet
2. Then Tools Protection Protect Sheet
3. Use a different password for each sheet and pass this on to each person

This way, only the person with the password can unprotect their own sheet
and unhide the rows to view/update data.

As I say...much better to use VBA but this would work.

As a side note, you probably only want the person to be able to view their
sheet and not make changes (unless you have very honest friends!) - you can
do this by protecting the cells from update (once the person has completed
their entry) but keeping this password to yourself

"Barb" wrote:

I have a football pool spreadsheet that has 20 'sheets', 1 for each person in
the pool. The 1st sheet has a combined summary of who has bet on what teams.
This will be hidden and seen only by me, since I am updating the final
scores. The rest of the sheets need to be protected so that only that person
can open their sheet. I know I can protect the workbook and protect the
worksheets, but this still allows everyone to 'view' everyone else's
worksheet.

Is there some way to protect the sheet so it can't be viewed unless with a
password? I'm not comfortable with VBA code, so please don't offer that
solution, although I'm sure it will be the best answer.
Thanks...