Lock Cells with Specify Range If Cells contains value
 

Hi,

Refer to Attachment, I have data in Range("A2:D3"), when button is
pressed this range should be locked. and Range("A4:D16") should
unlock.

Everytime update button is pressed, the program should check
Range("A2:D16"), and count which rows contain data, if row 1 & 2
contain data it should be locked, the rest should be unlock.

Rgds
Bernard


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4874 |
+-------------------------------------------------------------------+

--
bernardng
------------------------------------------------------------------------
bernardng's Profile: http://www.excelforum.com/member.php...o&userid=34117
View this thread: http://www.excelforum.com/showthread...hreadid=551284