Worksheet protection question

[Dominic]

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

 

[Jim Thomlinson]

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...

 

[Dominic]

Jim,
Thanks very much....that was ALOT less painful than I thought!!!!!
Take care.
Dominic

 

[JE McGimpsey]

Know that all internal protection is incredibly easy to bypass:

http://www.mcgimpsey.com/excel/removepwords.html