I have a spreadsheet that looks like below. When a user fills in the starting day in column B, ending day in column C, then days used is calculated in column D and days left are calculated in column E. Status is manually entered as ok in column F.
Days left starting day ending day Days used Days left Status 20.0 1-Jan 10-Jan 9.0 11.0 ok 11.0 3-Feb 5-Feb 2.0 9.0 ok Using VBA I want to lock the rows that have a status of ok in column F. Please help.
thanks
excelran
edit: duplicate thread removed
Days left starting day ending day Days used Days left Status 20.0 1-Jan 10-Jan 9.0 11.0 ok 11.0 3-Feb 5-Feb 2.0 9.0 ok Using VBA I want to lock the rows that have a status of ok in column F. Please help.
thanks
excelran
edit: duplicate thread removed