If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|