Individual sheet protection in shared workbook

[Sunil Pradhan]

I have a shared excel workbook with multiple sheets used by different people.
I want them to have their own password for their sheet so that only sheet
owner can edit the content of sheet. Please advise how do i do that?

 

[Dennis]

It is a two step process
1. Under tools> Protection Choose allow others to edit ranges
select the range then assign password each range should have
different PW
you can select entire sheet if you wish
2. Then tools>protection Pick protect worksheet
assign a password --- This protects the sheet and enables the range
password
unless this is done the range PW doesn't work
I use a different PW to protect the sheets this allows assigning PW
to several ranges on each sheet\

You can also set permissions on what can be changed or done on each
sheet/range
this makes it possible to have several permission levels per range depending