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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

worksheet specific password 1
Protect and Unprotect all worksheets with macro 2
allow a user to edit ranges in a protected worksheet 3
password protect allowances 1
Protection on Worksheets 5
Password Protection 6
Worksheet protected 2
Grouping with protected sheets (multiple sheets) 0

Back
Top