| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another cell protection question | Excel Discussion (Misc queries) | |||
| A Worksheet Protection Question | New Users to Excel | |||
| Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
| newbie protection question | New Users to Excel | |||
| Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Linear Mode
