I have the below macro to 'clear' data. I have a formula in D4 that rounds the value entered in D3.
How can I lock D4 to avoid anyone (even me - gottaAvoid****Happens) from editing the cell? The rounded number in D4 should only be copy-able - not editable.
How can I lock D4 to avoid anyone (even me - gottaAvoid****Happens) from editing the cell? The rounded number in D4 should only be copy-able - not editable.
VBA Code:
Sub Reset1()
Range("B2:B6").Value = Null 'clears search criteria
Range("A10:M" & Rows.Count).ClearContents 'clears resultant list of A10:M
Range("A9:M" & Rows.Count).Borders.LineStyle = xlNone 'clears previous "removeSpecials macro" borders
Range("E6").ClearContents 'clears high value
Range("E7").Value = "20" 'sets low value
Range("D3").Value = "verify 365 rnd"
Range("B5").Value = "fswp" 'sets default coverage
End Sub