Thank you dflac.

This is definitely what I was looking for . I am very much a novice at VBA - would I need to define CellRef for the range (i.e. only column C and D should remain locked and not the whole sheet)? Users should still be able to enter data on the rest of the sheet.