Individual sheet protection in shared workbook
 

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?

Individual sheet protection in shared workbook
 

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 toolsprotection 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
on the PW used
"Sunil Pradhan" wrote:

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?