I have a spreadsheet based checklist that is used to record Operators Check results completed on each shift throughout a week (21 shifts in total). Date / Shift end time fields are in B1:V1 with Check results in B2:V62. To prevent entries being altered post-shift end I need to lock each column based on a calculated field in each column (Row 63) that uses B1:V1 data to determine if a shift has ended with the appropriate Columns being locked. Does anyone have a suitable VBA code?