hi friends
i am maintaining time sheet for my emplpyees, every one hour our employees has to update there work in the time sheets, it's procedure, but my employees is entering all the update in one time (while leaving to home) , we couldn't control them , so i plan to instruct them to do every one hour they must enter or else ,the particular cell automatically locked for editing , we know final day who and all not update in to the time sheet,
for that i need the vba help for lock cells
sheet has 6 coloumns it value starts from "A7" to "F23" ( Column A is Sl.no, Column B is Project Name, Column C is Project Details, Column D is Start Time, Column E is End Time , Column F is Remarks)
Employee only update in Column B and Column C , and Column D and E will show the Start Time And End time (Sheet will deduct the start time automatically while opening sheet)
Star Time End-Time
10:10 11:10
11:10 12:10
12:10 13:10
13:10 14:10
14:10 15:10
15:10 16:10
16:10 17:10
17:10 18:10
18:10 19:10
19:10 20:10
20:10 21:10
suppose any one of the employee not enter the updates in column b, column c on that particular time , i need to disable edit option or lock the cell , how do i do this , could any one help me
(one of the employee not updated in time 11.10 to 12.10 in column b and c , cells should be locked (cell b8 and C8 cells should be locked)
conditions they need to update every 1 hour (1 to 1.10 hours) please help me in this issue )
regards
grlinks
i am maintaining time sheet for my emplpyees, every one hour our employees has to update there work in the time sheets, it's procedure, but my employees is entering all the update in one time (while leaving to home) , we couldn't control them , so i plan to instruct them to do every one hour they must enter or else ,the particular cell automatically locked for editing , we know final day who and all not update in to the time sheet,
for that i need the vba help for lock cells
sheet has 6 coloumns it value starts from "A7" to "F23" ( Column A is Sl.no, Column B is Project Name, Column C is Project Details, Column D is Start Time, Column E is End Time , Column F is Remarks)
Employee only update in Column B and Column C , and Column D and E will show the Start Time And End time (Sheet will deduct the start time automatically while opening sheet)
Star Time End-Time
10:10 11:10
11:10 12:10
12:10 13:10
13:10 14:10
14:10 15:10
15:10 16:10
16:10 17:10
17:10 18:10
18:10 19:10
19:10 20:10
20:10 21:10
suppose any one of the employee not enter the updates in column b, column c on that particular time , i need to disable edit option or lock the cell , how do i do this , could any one help me
(one of the employee not updated in time 11.10 to 12.10 in column b and c , cells should be locked (cell b8 and C8 cells should be locked)
conditions they need to update every 1 hour (1 to 1.10 hours) please help me in this issue )
regards
grlinks
