Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-09-2018, 04:14 PM
Marcia Marcia is offline Windows 7 32bit Office 2007
Competent Performer
 
Join Date: May 2018
Posts: 124
Marcia is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Book1.xlsx (53.0 KB, 4 views)
Reply With Quote
  #2  
Old 11-25-2018, 06:00 AM
p45cal p45cal is offline Windows 10 Office 2016
Competent Performer
 
Join Date: Apr 2014
Posts: 206
p45cal will become famous soon enough
Default

Remove conditional formatting.
You'll be left with the style of the Table but you can change that.
Reply With Quote
  #3  
Old 11-26-2018, 06:34 PM
Marcia Marcia is offline Windows 7 32bit Office 2007
Competent Performer
 
Join Date: May 2018
Posts: 124
Marcia is on a distinguished road
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
  #4  
Old 11-26-2018, 06:49 PM
p45cal p45cal is offline Windows 10 Office 2016
Competent Performer
 
Join Date: Apr 2014
Posts: 206
p45cal will become famous soon enough
Default

Quote:
Originally Posted by Marcia View Post
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.
Reply With Quote
  #5  
Old 11-27-2018, 10:20 AM
Marcia Marcia is offline Windows 7 32bit Office 2007
Competent Performer
 
Join Date: May 2018
Posts: 124
Marcia is on a distinguished road
Default

Please see attached file, thanks... the color is pink.
Attached Files
File Type: xlsx Book2.xlsx (244.0 KB, 3 views)
Reply With Quote
  #6  
Old 11-27-2018, 03:56 PM
p45cal p45cal is offline Windows 10 Office 2016
Competent Performer
 
Join Date: Apr 2014
Posts: 206
p45cal will become famous soon enough
Default

You still have loads of conditional formattting in there:
Reply With Quote
  #7  
Old 11-29-2018, 08:11 AM
Marcia Marcia is offline Windows 7 32bit Office 2007
Competent Performer
 
Join Date: May 2018
Posts: 124
Marcia is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
You still have loads of conditional formattting in there:

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.
Reply With Quote
  #8  
Old 11-29-2018, 09:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,256
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

@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)
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #9  
Old 11-30-2018, 04:42 AM
Marcia Marcia is offline Windows 7 32bit Office 2007
Competent Performer
 
Join Date: May 2018
Posts: 124
Marcia is on a distinguished road
Default

You did advise me Pecoflyer. I'll keep this in mind, thank you.
Reply With Quote
Reply

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


All times are GMT -7. The time now is 12:23 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft