why doesn't code reset cell color back?

**rgouette** · 06-13-2014, 11:06 AM

Issue: vba code in worksheet won't revert a changed cells color back to 0(white) after removing the comment
Observations: code does set the desired cell colors to Yellow after inserting a comment, however removing said comment,
and re-activating the worksheet does NOT reset the color after deactivating/re-activating the worksheet.

Please Login or Register  to view this content.

Thanks,
Rich

**AB33** · 06-13-2014, 11:11 AM

To remove colour

Please Login or Register  to view this content.

**Izandol** · 06-13-2014, 11:32 AM

This code will not work. If there will be no comments on the sheet and rngComments will be Nothing, it will not have Interior property (it will not be Range object) and error will occur. You must monitor all cells with comments or you must clear fill from all cells and colour only comment cells.