Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
allow a user to edit ranges in a protected worksheet
Hi all.
This one has been seen in the past, I run Excel 2003 and have a spreadsheet with 20 worksheets. I want each worksheet to be protected by 1: an administrator password, 2: a user password. the user password for worksheet 2 MUST NOT be able to edit any of the other worksheets and vice versa. I have followed the instructions for allowing users to edit ranges in a protected worksheet. 1. I assign specific names / permissions and complete with a password 2. Protect the sheet only allowing specific actions to be completed, e.g. unlocked cells only, use of filters and sorting with a different password 3. Protect and share the workbook with a different password However it just doesn't seem to want to work for me and when I've had someone not on the allowed list go in to edit the sheet they can enter data and save. Does anyone know what I'm doing wrong - before I become totally bald |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tabbing thru User-Edit Cells in Protected Sheet | Excel Discussion (Misc queries) | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Edit Range of a protected worksheet | Excel Worksheet Functions | |||
How do I allow users to edit links in a protected worksheet? | Excel Worksheet Functions | |||
Can't Edit Contents of Protected Worksheet | Excel Discussion (Misc queries) |