| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protect worksheets in workbook
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... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
| How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
| Hide and PW protect multiple worksheets | Excel Worksheet Functions | |||
| How do I build a workbook from the worksheets another workbook? | Excel Discussion (Misc queries) | |||
| No password protect workbook box in Tools>Options>General | Excel Discussion (Misc queries) | |||
Threaded Mode
