Formula appear all the zeros in cells

Please Login or Register  to view this content.

I have some formula in some of the cells for example =SUM(H9:H23) AND =IF(AF82=TRUE,20,0)…
The cells were blank until I enter something in H9:H23.

But once I added these code in the thisworkbook module then when I entered something from the cell then all the zeroes appear in all where the formula are. There so many zeroes it appeared in the workbook. It should only correspond what the formula is. Let say if I enter $320 in H9 cell then it only should show the total where the formula =sum(h9:h23).

This is only it happened when I added the “color tab” vba code.

Please Login or Register  to view this content.

Thanks in advance.

Please Login or Register  to view this content.

I need someone to fix this for me so that the formula in any cells will not be change by this code.