Thread: [Solved] How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange
View Single Post
 
Old 11-26-2018, 06:34 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by p45cal View Post
Remove conditional formatting.
You'll be left with the style of the Table but you can change that.

I deleted all conditional formatting in the sheet and emptied all the VBE modules of any macro but the color is still there. It's now nearing the end of the fiscal year so I guess I will just bear with the nuisance and start a whole new sheet next year.
Reply With Quote