Locking cells

Giganews Newsgroups
Subject: Locking cells
Posted by:  Elfego Baca (livelong…@gmail.com)
Date: Wed, 17 Jan 2007

Can anyone tell me how to program a cell so that it locks automatically
when another cell is filled. For example I have a row with 5 cells,
A1,A2,A3,A4,A5.  As soon as I enter anything in A1 I want cells A2,A3,A4
and A5 to lock and remain locked until the manager comes and enters a
password that allows that line to be unlocked. IS there a way to do this?

Replies