Worksheet protection question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
Jim,
Thanks very much....that was ALOT less painful than I thought!!!!!
Take care.
Dominic
 
Back
Top