Conditional cell protection


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?
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Returned position address on protected sheet 7
Allow VBA code to change a locked cell?? 2
Select statement or me? 12
Locking / Unlocking Cell with out Protection/ Unprotection of Shee 3
Password Cell Protection 1
Using cell color in conditional format makes Excel unstable 2
Programmatically setting Conditional Formatting to a range of cells 7

Top