Just some brief hints:
I have a program that does a similar thing so I am using what I have,
hopefully it will be of help


' lock whole worksheet, for example
Range("A1:AJ" & row_results + 1).Locked = True

' then unlock the cells you want to be editable, example
ws.Range("A" & merge_cntr + 3 & ":AA" & merge_cntr + 3).Locked = False

' then you need to protect the worksheet (you can add a password to
unprotect ex for administrator)
ws.Protect Password:="pass"



tahir wrote:
I have been hitting my head with the wall since i m new to VBA, i wish
to block the whole sheet for data entry except the very first row for
data entry. as the user complete the first row for data entry, He/She
will press a button to paste the record to another sheet and after
pasting the row will be locked but the next row will be available for
entry. for example if i am entering data on a range A1 to AA1 then the
remaining rows must be locked. and as soon as i finish entry till AA1
and press macro button then this particular row should be pasted to
another sheet lets say sheet3. and as soon as the record is pasted, the
row A1:AA1 must be locked and the next row A2:AA2 must be available for
entry and rest of the rows must be locked. and the cycle will continue
uptil lets say for 200 rows.

Regards,

Darno


--
tahir

Student, working on a project
------------------------------------------------------------------------
tahir's Profile: http://www.excelforum.com/member.php...fo&userid=6053
View this thread: http://www.excelforum.com/showthread...hreadid=524816