|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange
Hello, please help me with eliminating the messy colored fill in the attached sheet. I installed a Private Sub Worksheet_Selection Change macro but it was slowing down my data entry work so I deleted the macro. I saved the macro-free file as .xlsx but the color spread out in random into the other parts of my sheet. I tried the "no fil" option but the pesky color remained. Thank you. |
#2
|
||||
|
||||
Remove conditional formatting.
You'll be left with the style of the Table but you can change that. |
#3
|
||||
|
||||
Quote:
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. |
#4
|
||||
|
||||
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.
|
#5
|
||||
|
||||
Please see attached file, thanks... the color is pink.
|
#6
|
||||
|
||||
You still have loads of conditional formattting in there:
|
#7
|
||||
|
||||
My goodness. Where did the conditioning formula come from? I'm sure I did not place them there because I don't even understand what it is trying to format. Anyway, thank you, I opened the real file and found out the loads of conditional formatting your were referring to and deleted them. |
#8
|
||||
|
||||
@Marcia
I think I have already asked you to NOT quote entire posts unnecessarily. The quotes make threads hard to read and are just clutter. Thank you ( If I did not, sorry)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#9
|
||||
|
||||
You did advise me Pecoflyer. I'll keep this in mind, thank you.
|
Thread Tools | |
Display Modes | |
|
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 |