+ Reply to Thread
Results 1 to 2 of 2

VBA to Change all Red font to ;;; making it invisible

  1. #1
    Registered User
    Join Date
    07-17-2014
    Location
    birmingham
    MS-Off Ver
    2003
    Posts
    3

    VBA to Change all Red font to ;;; making it invisible

    Hi I've lost my code I used to use for VBA excel which found all text in red font (255) and change the number format to ;;; making it invisible

    Please can someone help me and post a code that would work?

    Id need it to search my current work tab (I don't use more than 1 tab on each of my quotation templates, at work)


    This is very handy for me, as there can be multiple pages and when I set a shortcut for this to run with pdf and email its saves me hours of time

    Thank you

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    3,867

    Re: VBA to Change all Red font to ;;; making it invisible

    .
    Here is a method of changing the font color (if red) to the background color ... effectively making it invisible.

    Please Login or Register  to view this content.
    DEPLORABLE : A hard working, tax paying, patriotic American. That's me !

    Cats. Because People Suck.

    If someone has assisted you in any way, please be respectful to acknowledge it.
    Simply saying "Thank you" will suffice. If you are so moved, adding to their reputation by clicking
    <------ Add Reputation is a very nice gesture.
    When your question has been answered, Please mark the thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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