Prev: Sort by Colour
Next: LINECOLOUR CHANGE IN EXCEL WORKSHEET?
From: Sunil Pradhan on 15 May 2010 13:13
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?
From: Dennis on 15 May 2010 22:51
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
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?
 | 
Pages: 1
Prev: Sort by Colour
Next: LINECOLOUR CHANGE IN EXCEL WORKSHEET?