Conditional cell protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If the value in cell A1 <= 0 I want to be able to change the protection on
another range of cells from unlocked to locked. Any ideas how this can be
done?
 
use the change event or the calculate event. It depends on how the value
will become less than zero.

http://www.cpearson.com/excel/events.aspx

beyond that, you have to unprotect the sheet and set the locked property to
false (or true) then reprotect the sheet. Code can be captured with the
macro recorder if you are not familiar.
 
Back
Top