I have a workbook with multiple sheets where user can enter their weekly
payroll summary data. On a weekly recap sheet there are two sections, one to
input hours worked that were paid in the same month for each pay week. The
other section to record hours worked but not paid (meaning accrued hours).
A simplified example is as follows:
Week ST Hours 1.5 Hrs 2.0 Hrs T hours
Prior -2680.40 -350.20 0.0 -350.20
05/01/05 2680.40 350.20 0.0 350.20
05/08/05 2752.20 320.90 0.0 320.90
05/15/05 2755.70 327.70 0.0 327.70
05/22/05 2733.00 352.30 0.0 352.30
05/29/05 0.00 0.00 0.0 0.0
Paid Sum 10921.10 1351.10 0.0 1351.10
Accr CL 0.0 0.0 0.0 0.0
Accr NCL 0.0 0.0 0.0 0.0
Tot Accr 0.0 0.0 0.0 0.0
Total Wrkd 10921.10 1351.10 0.0 1351.10

I want to prevent user from inputting hours summary for the week ending
05/29/05
in the top section since the pay will not be paid until Friday 06/03/05. So
the either using formulas or VBA code I want to either greyout or lock the
cell for input on the row which is showing 05/29/05. Better yet I want to be
able to move the date to row with label Accr CL.
Currently the first week which get paid in a month is pulled from a table
after looking at month. The 2nd pay week is derived by adding 7 to the first
week date and so on for the rest of weeks in the month.
The row Accr NCL is there to record hours of a split week between the last
Sunday of the month and the last day of month that is 05/30/05 to 05/31/05.
The user does not put the dates it is done as part of the reset procedure
for new month as I explained above.
Any suggestions, example code or formulas to accomplish this task will be
highly appreciated.