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...

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...

Boo, the 1st part works great, however, how do I password protect the sheet
after they've made their selections with a different password so they can
make any additional changes? Do I just 'lock' the cells, but wouldn't they
be able to 'unlock' them with the password?
Thanks...

"Boo" wrote:

> 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...

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 <(E-Mail Removed)> 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...

However, note that it's absolutely trivial to see the contents of the
hidden rows without knowing the password:

Say you want to see what's on sheet "Bob". Create a blank sheet, and
enter this in cell A1:

=Bob!A1

Copy down and across as far as necessary. You'll see everything on "Bob".

Of course, unprotecting a sheet is also absolutely trivial:

http://www.mcgimpsey.com/excel/removepwords.html




In article <7995E17E-D13F-45B5-A6BA-(E-Mail Removed)>,
Boo <(E-Mail Removed)> wrote:

> 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.

Hey!


This theme is relevant for me as well. I like the idea about making a
summary woorkbook with links. But how does it work?


Thanks!

"Gord Dibben" skrev:

> 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 <(E-Mail Removed)> 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...
>
>

See help on "linking" then click on "about linking to another workbook or
program"


Gord

On Tue, 25 Sep 2007 14:10:00 -0700, Aron <(E-Mail Removed)> wrote:

>Hey!
>
>
>This theme is relevant for me as well. I like the idea about making a
>summary woorkbook with links. But how does it work?
>
>
>Thanks!
>
>"Gord Dibben" skrev:
>
>> 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 <(E-Mail Removed)> 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...
>>
>>