Each worksheet can have a unique password. All you have to do is assign that
password to the sheet. Of course you also have to remember what the password
is for each of the sheets.

As long as the people using the workbook are 'honest' and all you're
interested in doing is keeping users from accidentally altering someone
else's data or using the wrong sheet, then things are fine. But remember
that the encryption of the password for both workbook and worksheet
protection is very weak and easily cracked - so it's not much for providing
true 'security' type protection.

You could put code in each worksheet's _Activate() event to prompt for its
password, and if the proper password isn't given, leave the sheet locked up.
Another person posting a question about this kind of thing had such a deal
set up: when you activated a sheet, it first hid all of the columns on that
sheet and requested the password. If the proper password wasn't given, then
the columns remained hidden (and the sheet remained protected), but if the
proper password was given, then the columns were made visible and sheet
protection was removed. The sheet's _Deactivate() event handler was set up
to always put the sheet back into protected state with the columns hidden
again.

Here's a link to their initial posting that shows the code they used in the
two worksheet events:
http://www.microsoft.com/office/comm...f-4da09fdbbed5



"Kristi" wrote:

I have a shared document that needs to be set up so that individuals can
access only the worksheet for them (no others) as well as protected cells
within that worksheet. I have set the passwords for the sheets as far as the
data is concerned, but is it possible to protect each worksheet with an
additional password or can only one password be used per worksheet? The
trouble is that one individual could/would enter data on anothers worksheet.