Followed Hyperlink Font Color

  • Thread starter Thread starter mustang25
  • Start date Start date
M

mustang25

Is there a way to set hyperlinks in Excel to stay the same color after they
have been clicked as they were before they were clicked? Right now they
start out blue, but when I click on them they turn purple. I'd rather they
stayed blue (or whatever other color I set them up to be to begin with).

Thanks in advance.
 
Try this:

Create a hyperlink in a cell
Click on the hyperlink to follow it.

Select Excel again
From the Excel Main Menu:
<format><style>

You'll see 2 new styles listed in the drop down:
Hyperlink
and
Followed Hyperlink

Select: Hyperlink......Click [Modify]....Note the settings.
Select: Followed Hyperlink......Click [Modify]
......use the same settings as the Hyperlink style

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Ron,

That worked perfectly! Thank you!

Ron Coderre said:
Try this:

Create a hyperlink in a cell
Click on the hyperlink to follow it.

Select Excel again
From the Excel Main Menu:
<format><style>

You'll see 2 new styles listed in the drop down:
Hyperlink
and
Followed Hyperlink

Select: Hyperlink......Click [Modify]....Note the settings.
Select: Followed Hyperlink......Click [Modify]
......use the same settings as the Hyperlink style

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

mustang25 said:
Is there a way to set hyperlinks in Excel to stay the same color after
they
have been clicked as they were before they were clicked? Right now they
start out blue, but when I click on them they turn purple. I'd rather
they
stayed blue (or whatever other color I set them up to be to begin with).

Thanks in advance.
Click to expand...
Click to expand...
 
You're very welcome!....I'm glad I could help.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

mustang25 said:
Ron,

That worked perfectly! Thank you!

Ron Coderre said:
Try this:

Create a hyperlink in a cell
Click on the hyperlink to follow it.

Select Excel again
From the Excel Main Menu:
<format><style>

You'll see 2 new styles listed in the drop down:
Hyperlink
and
Followed Hyperlink

Select: Hyperlink......Click [Modify]....Note the settings.
Select: Followed Hyperlink......Click [Modify]
......use the same settings as the Hyperlink style

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

mustang25 said:
Is there a way to set hyperlinks in Excel to stay the same color after
they
have been clicked as they were before they were clicked? Right now
they
start out blue, but when I click on them they turn purple. I'd rather
they
stayed blue (or whatever other color I set them up to be to begin
with).

Thanks in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top