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