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

Regards,

Darn

--
tahi

Student, working on a projec
-----------------------------------------------------------------------
tahir's Profile: http://www.excelforum.com/member.php...nfo&userid=605
View this thread: http://www.excelforum.com/showthread.php?threadid=52481