Results 1 to 6 of 6

Thread: Excel 2016 will no record macros to change text color
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2015
    Location
    Atlanta GA
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel 2016 will no record macros to change text color

    I am running Excel 2016 and have tried to record simple macros that just change the font color. Nothing is recorded. The same happens for other text changes like bold, highlight, italics. I can manually type in Selection.Font.Color = vbRed into the macroand it works.

    Anyone know what is happening here and how to fix it?

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,813
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Excel 2016 will no record macros to change text color

    Welcome to the Board!

    I have never heard of that happening. Do you have multiple sessions of Excel open at once?
    I am wondering if you are recording macros in one session, but applying the formatting changes to a different Excel session.
    When this happens, are you able to get ANY code to show up at all?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    New Member
    Join Date
    Aug 2015
    Location
    Atlanta GA
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel 2016 will no record macros to change text color

    I am only running one instance of Excel and when I try to record nothing shows up in the Macro. If I include text changes in other lines, the others show up but not the text changes.

  4. #4
    Board Regular
    Join Date
    May 2019
    Posts
    220
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel 2016 will no record macros to change text color

    Quote Originally Posted by ksadeckas View Post
    I am running Excel 2016 and have tried to record simple macros that just change the font color. Nothing is recorded. The same happens for other text changes like bold, highlight, italics. I can manually type in Selection.Font.Color = vbRed into the macroand it works.

    Anyone know what is happening here and how to fix it?
    Are you using conditional Formatting? I've heard of the macros not recording when using "Manage Rules", but working when clicking "New Rule"

  5. #5
    New Member
    Join Date
    Aug 2015
    Location
    Atlanta GA
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel 2016 will no record macros to change text color

    Quote Originally Posted by Twollaston View Post
    Are you using conditional Formatting? I've heard of the macros not recording when using "Manage Rules", but working when clicking "New Rule"
    I am not using conditional formatting. I just want to highlight cells manually using a macro. I use it when I am reviewing Excel reports to highlight issues.

  6. #6
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,813
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Excel 2016 will no record macros to change text color

    If you open up a brand new Excel file, turn on the Macro Recorder, enter an entry into cell A1 and then try to apply some formatting to it, and then stop the Macro Recorder, how much of that gets recorded?
    If that all works, then it points to something with the particular file that you are working on?
    Is it truly an Excel file? How is the file being created?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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