Password Protecting Cells

[Bern Notice]

Can you protect different cells in a workbook with different passwords? For
example, we have different departments that complete particular sections of a
spreadsheet and we would like to be able to password protect each departments
section with a different password.

Thanks,
Bernie J.

 

[AltaEgo]

Gord Dibben has some code here that can be modified:

http://www.eggheadcafe.com/conversation.aspx?messageid=32445330&threadid=32445325


Where Gord unlocks columns, you might unlock ranges. Example:

Case Is = "Steve": Range("A3:B30").Cells.Locked = False

Note that that Gord did not include an Else in his example (or some other
means) to handle incorrect passwords.

 

[Dave Peterson]

Depends on the version.

I _think_ xl2002 was the first to offer this.

Tools|Protection|allow users to edit ranges
(in xl2003 menus)