+ Reply to Thread
Results 1 to 2 of 2

Thread: Reset Hyperlink color

  1. #1
    Registered User
    Join Date
    11-06-2007
    Posts
    48

    Reset Hyperlink color

    How does one reset the color of a hyperlink programmatically?

    Anyone have any ideas?

    Thanks
    Last edited by jmicdk; 02-17-2009 at 07:41 PM.

  2. #2
    Registered User
    Join Date
    11-06-2007
    Posts
    48

    Re: Reset Hyperlink color

    This does not reset it, but will change the format of the followed link globally.

    For wehat i want to do this is good enough

        With ActiveWorkbook.Styles("Followed Hyperlink").Font
            .Name = "Arial"
            .Size = 9.5
            .Bold = False
            .Italic = False
            .Underline = xlUnderlineStyleSingle
            .Strikethrough = False
            .ColorIndex = 5
        End With

+ 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.2.0