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
|
|||
|
|||
Worksheet protection question
Hi all.
I have a spreadsheet with 20 worksheets. I want each worksheet to be protected by 1: an administrator password, 2: a user password. the user password for worksheet 2 MUST NOT be able to edit any of the other worksheets and vice versa. Is this possible? Thanks in advance for your help..... waiting patiently.... Dominic |
#2
|
|||
|
|||
Worksheet protection question
Assuming you have XL2002 or better you can look at Tools - Protection -
Allow Users to Edit Ranges which will allow you to specify different levels of protection based on the user... -- HTH... Jim Thomlinson "Dominic" wrote: Hi all. I have a spreadsheet with 20 worksheets. I want each worksheet to be protected by 1: an administrator password, 2: a user password. the user password for worksheet 2 MUST NOT be able to edit any of the other worksheets and vice versa. Is this possible? Thanks in advance for your help..... waiting patiently.... Dominic |
#3
|
|||
|
|||
Worksheet protection question
Jim,
Thanks very much....that was ALOT less painful than I thought!!!!! Take care. Dominic "Jim Thomlinson" wrote: Assuming you have XL2002 or better you can look at Tools - Protection - Allow Users to Edit Ranges which will allow you to specify different levels of protection based on the user... -- HTH... Jim Thomlinson "Dominic" wrote: Hi all. I have a spreadsheet with 20 worksheets. I want each worksheet to be protected by 1: an administrator password, 2: a user password. the user password for worksheet 2 MUST NOT be able to edit any of the other worksheets and vice versa. Is this possible? Thanks in advance for your help..... waiting patiently.... Dominic |
#4
|
|||
|
|||
Worksheet protection question
Know that all internal protection is incredibly easy to bypass:
http://www.mcgimpsey.com/excel/removepwords.html In article , Dominic wrote: the user password for worksheet 2 MUST NOT be able to edit any of the other worksheets and vice versa. |
Thread Tools | |
Display Modes | |
|
|