cells protection

  • Thread starter Thread starter gulp!
  • Start date Start date
G

gulp!

Hello,
is it possible to protect different cells group of a sheet
with different password so that different users can have
possibility to modify only some cells and not others?

Thanks
 
I believe there is only one password per sheet. You might be able to
implement something in code, but such protection is easily overcome (either
code or protecting a sheet with a password).

You might make a separate workbook for each group of users and develop a
method to consolidate the data from each in a single separate workbook.
 
I knew about the sheet tabs colors and the ability to work with protection
applied to specific users. But I didn't realize you could assign separate
passwords to each range. Guess I will have to install it on the main
computer or walk downstairs and play with it.
 
This time, _I_ was going for the humorous effect.

Tom said:
I knew about the sheet tabs colors and the ability to work with protection
applied to specific users. But I didn't realize you could assign separate
passwords to each range. Guess I will have to install it on the main
computer or walk downstairs and play with it.
Click to expand...
 
Thanks Debra.

Done any testing/exploration on this with JE McGimpsey's/Norman Harker's
password breaking code?
 
Thanks again for the references.

Didn't mean to put you to any trouble. Just wondered if you had looked into
it. Seems no additional strength if the removal of protection removes the
range protection as well - but it makes sense.
 
Back
Top