How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange

p45cal · #1 11-25-2018, 06:00 AM

Remove conditional formatting.
You'll be left with the style of the Table but you can change that.

Marcia · #2 11-26-2018, 06:34 PM

Quote:

Originally Posted by p45cal

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.

p45cal · #3 11-26-2018, 06:49 PM

Quote:

Originally Posted by Marcia

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.

Which colour is still there? I mentioned you'd still have the Table's style colouring. Perhaps attach your current sheet so we can see what's left.

Marcia · #4 11-27-2018, 10:20 AM

Please see attached file, thanks... the color is pink.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove white text background (keeping the font color and page color intact	cc3125	Word	1	10-26-2015 06:44 PM
Auto Color Fill Question	Kinar	Excel	3	05-14-2013 07:46 AM
Fill Color	curtis.walker@sgmc.org	Excel	4	03-15-2013 12:30 PM
Outlook 2010 - Color Private appointments	marcc	Outlook	0	03-09-2012 03:21 AM
remove deleted doc from task pane	Crusader	Word	1	06-28-2011 03:50 PM