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

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

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

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.