Results 1 to 10 of 10

Macro changing font color to white instead of gray

Threaded View

bwmuhich Macro changing font color to... 03-19-2015, 06:11 PM
NoSparks Re: Macro changing font color... 03-19-2015, 07:34 PM
bwmuhich Re: Macro changing font color... 03-19-2015, 07:51 PM
NoSparks Re: Macro changing font color... 03-19-2015, 07:55 PM
bwmuhich Re: Macro changing font color... 03-19-2015, 07:59 PM
Blokeman Re: Macro changing font color... 03-19-2015, 08:49 PM
bwmuhich Re: Macro changing font color... 03-20-2015, 10:29 AM
NoSparks Re: Macro changing font color... 03-19-2015, 09:18 PM
Blokeman Re: Macro changing font color... 03-20-2015, 07:53 PM
Philb1 Re: Macro changing font color... 03-20-2015, 10:40 PM
  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Elgin, IL
    MS-Off Ver
    Excel 2010
    Posts
    90

    Macro changing font color to white instead of gray

    Hello excel forum. I have what I think should be a fairly straightforward Marco, but when I run it, it changes the font color in the referenced cells white instead of dark gray. I deleted the macro I had recorded twice and recorded two additional times and each time I encounter the same issue.

    Why doesn't the macro change the font color to dark gray as when I record it?

    Attached is the sample worksheet with 2 macros. The "HIDE" button runs the macro that is operating correctly, which hides rows 65 and 66, and changes the font type in rows 63 and 645 from dark gray, unbolded, 10 point font to black, bold, 12 point font.

    The Unhide button is supposed to run the macro that reverses what the first Macro did, so I've recorded it to unbold the data in rows 63 and 64, change the font size back to 10 and color from black to dark gray, and unhide rows 65 & 66. The macro does everything correctly, except it changes the font to white instead of dark gray.

    Can anyone guide me to the solution to my problem?

    Be Well,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to add data labels and color font white in Active Tab for all charts?
    By Dude to Excel Dude in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2014, 01:54 PM
  2. Changing font Color linked to Date Key through macro
    By JPSIMMON in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2014, 04:38 PM
  3. [SOLVED] For all cells with font size bigger than 9, make that cell bold and color white
    By jasondu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2012, 02:18 PM
  4. Macro to change cell background from gray to white
    By t0m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2011, 04:08 PM
  5. Fill Color and Font Color stay Black and White
    By Hors Categorie in forum Excel General
    Replies: 1
    Last Post: 05-10-2005, 07:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1