View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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