Insert a row without taking formats from the upper row or cells

[thelordmorgoth]

I guess I need a VB code (or anything else) to prevent the excel from inheriting formats from upper row when I insert a row under a formatted row.

I know there is option to disable it but I need it only effects to one excel sheet which also has other VB codes.

I would also appreciated If you also you show me how I can code to prevent certain type of formats. I mean, the I inserted row only inherits "BOLD" from the upper row. A reference of functions would help.

Thanks