To start, be aware that Excel is not designed to be a secure platform.
Whatever scheme you come up with can be broken by someone with sufficient
Excel knowledge.
Having said that, may I make a suggestion? Set up each sheet as to locked
and unlocked cells as you wish and protect it without a password.
Have one blank sheet that will be visible at all times (because you can't
hide all the sheets).
Have another sheet that contains only 2 columns of data, the list of sheet
names and the corresponding passwords you want to use.
Set all the sheets to VeryHidden, except for the one blank sheet. The
setting of VeryHidden precludes the casual user from unhiding that sheet
because only VBA code can unhide a VeryHidden sheet.
Use a Workbook_Open event macro to display an InputBox that asks the user to
type in his password. The user does and the code will determine the sheet
that goes with that password, and will unhide that sheet and select that
sheet as the active sheet on the screen.
You can also use a Workbook_BeforeClose event macro that will set all sheets
(except the blank sheet) to VeryHidden when the file is closed.
If multiple users will be accessing the same file without closing it, you
can have a button on each sheet to close that sheet (set it to VeryHidden)
when the user is through with it.
Does this sound anything like what you want? HTH Otto
"McA" wrote in message
...
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