cells protection

[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

 

[Tom Ogilvy]

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.

 

[Dave Peterson]

xl2002 added that feature.

Tools|Protection|Allow Users to Edit Ranges

 

[Tom Ogilvy]

It added the ability to assign separate passwords to each range.

Wow!

 

[Dave Peterson]

And colored worksheet tabs, too!

It added the ability to assign separate passwords to each range.

Wow!

 

[Tom Ogilvy]

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.

 

[Debra Dalgleish]

There are instructions in the following MSKB article:

HOW TO: How to Apply Different Passwords or Permissions to Separate
Ranges in Worksheets in Excel 2002
http://support.microsoft.com/?kbid=289270

 

[Tom Ogilvy]

Thanks Debra.

Done any testing/exploration on this with JE McGimpsey's/Norman Harker's
password breaking code?

 

[Debra Dalgleish]

Their code removes the sheet protection, which unlocks the ranges. Once
the sheet is unprotected, you can delete or modify the ranges, or set
new passwords.

There's some programming information here:

Using the Protection Object to Protect Your Worksheets

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlwebProtSht.asp

 

[Tom Ogilvy]

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.