View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dominic Dominic is offline
external usenet poster
 
Posts: 26
Default 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