Lock Cells with Specify Range If Cells contains value

B

bernardng

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 |
+-------------------------------------------------------------------+
 

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
Naming non-contigent cells with vba 5
unlock cells if value is... 1
Lock or Unlock Range of Cells on Worksheet_Change Event 3
Return a value if a range of cells contain text 2
Lock certain cells from edit- test if select cell name starting wi 2
New topic from discussion "Align cells with same value - vba almostworking" in this group 0
class range...select...(reserved for expert) 4

Top