protect worksheets in workbook

G

Guest

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

Guest

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
 
G

Guest

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

Gord Dibben

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
 
J

JE McGimpsey

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
 
G

Guest

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:
 
G

Gord Dibben

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


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top