Barb

The sheets need to be hidden and the workbook structure protected.

Unfortunately, unless the sheets are veryhidden(VBA) unprotecting the workbook
will allow anyone to unhide any sheet.

Without VBA I would suggest you move each person's worksheet to a new workbook.

You can link your summary workbook to the others and each workbook will have its
own password to open.


Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 13:34:02 -0700, 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...