Conditional locking of cell based on another cell

This is for Excel 2007. I simply want to lock cell H20 and make it's value equal to zero if anything other than 0 is entered into H19. And vice versa (make H19 equal to 0 and lock it if anything greater than 0 is entered into H20). So only one cell can hold a value not equal to zero at a time, and the one that is zero needs to be locked.

Here's what I have so far. It locks H20 based on H19 being > 0, but doesn't do the vice versa part. And it also doesn't make H20 = 0 when it locks it.
Thanks!

Please Login or Register  to view this content.

Hi,

Try this code

Please Login or Register  to view this content.

It looks OK when I tested in Excel 2003.

FYI, when you protect a worksheet all cells are protected / locked by default. So if you need cells other than H19 and H20 to be unprotected you have to do that explicitly. If you need more info please check this post:

http://www.exceldigest.com/myblog/20...n-a-worksheet/

Regards.

Hi,

In response to your message regarding password:

To unlock the sheet for the first time you can add this to the worksheet _Activate event:

Please Login or Register  to view this content.

Subsequently you can modify the lines in the code to protect the sheet in the macro as follows:

Please Login or Register  to view this content.

Of course you will change the password to whatever your actual password is.

Regards.