Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2018, 04:14 PM
Marcia's Avatar
Marcia Marcia is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 7 32bit How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2007
Expert
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
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, 10 views)
Reply With Quote
  #2  
Old 11-25-2018, 06:00 AM
p45cal's Avatar
p45cal p45cal is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 10 How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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's Avatar
Marcia Marcia is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 7 32bit How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2007
Expert
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange
 
Join Date: May 2018
Location: Philippines
Posts: 526
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
  #4  
Old 11-26-2018, 06:49 PM
p45cal's Avatar
p45cal p45cal is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 10 How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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's Avatar
Marcia Marcia is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 7 32bit How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2007
Expert
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Please see attached file, thanks... the color is pink.
Attached Files
File Type: xlsx Book2.xlsx (244.0 KB, 9 views)
Reply With Quote
  #6  
Old 11-27-2018, 03:56 PM
p45cal's Avatar
p45cal p45cal is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 10 How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

You still have loads of conditional formattting in there:
Reply With Quote
  #7  
Old 11-29-2018, 08:11 AM
Marcia's Avatar
Marcia Marcia is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 7 32bit How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2007
Expert
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
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 How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 7 64bit How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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)
__________________
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
Reply With Quote
  #9  
Old 11-30-2018, 04:42 AM
Marcia's Avatar
Marcia Marcia is offline How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Windows 7 32bit How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Office 2007
Expert
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
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
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Remove white text background (keeping the font color and page color intact cc3125 Word 1 10-26-2015 06:44 PM
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange Auto Color Fill Question Kinar Excel 3 05-14-2013 07:46 AM
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange 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
How to remove color fill remnant from a deleted Private Sub Worksheet_SelectionChange remove deleted doc from task pane Crusader Word 1 06-28-2011 03:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft