Row B and C both need to be locked to prevent the user from entering data,
however, I have code that puts a formula into these cells when the user
enters a date into Cell A. When I lock the cells and protect the sheet, I
get an error because the code it trying to add the formula to a locked cell.
Is there any way around this?

Thanks,
Kevin