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