User edit or input any value only below range ( yellow highlighter). other cell did not selected.
Worksheet “Bill” cell range F5,F7,F9,F11,F13,C16,D16,E16,F16,G16, AND B19 : F28, G32
Was unlock manually by review tab in protect sheet under uncheck “select locked cells” and password was “123”.
now when I enter any value in range E19:F28 then debag error show.
(formula E19 * F19 and output in cell range (19:G28)
Formula be put in “Bill” sheet in Worksheet Change event.
I upload file and password is “123”
Worksheet “Bill” cell range F5,F7,F9,F11,F13,C16,D16,E16,F16,G16, AND B19 : F28, G32
Was unlock manually by review tab in protect sheet under uncheck “select locked cells” and password was “123”.
now when I enter any value in range E19:F28 then debag error show.
(formula E19 * F19 and output in cell range (19:G28)
Formula be put in “Bill” sheet in Worksheet Change event.
I upload file and password is “123”
