Need to Have Specific Excel Macro VBA Code Hard Wired

Hi,

See attached file. I require a couple of minor amendments in macro code as follows;

* If user enters code at D7, this code should auto copy to D11, D13, D15, D17, D19 and these codes should become hard wired (user cannot override).

* If user enters REF to Edit (C3), then D7 or D11 only should become editable and then existing rules apply as above and as already coded in workbook. All columns should auto fit.

Looking forward to helpful response. Thanks!