Prevent hyperlink to change the color

[BS Singh]

Hi,

If anybody add sheet in the workbook then following code create a hyperlink in the first sheet of the workbook with new sheet name. On following the hyperlink, i would like to prevent Excel from changing the color of linked text.

Is there any way round using VBA for this??

Thanks for your help.

Please Login or Register  to view this content.

[humdingaling]

http://superuser.com/questions/72882...a-clicked-link

Modify the theme used for a Followed hyperlink to be the same as an unfollowed hyperlink:

Page Layout tab of the ribbon
Click Colors in the Themes group
Click Create New Theme Colors
Set Followed Hyperlink color to same as Hyperlink

[BS Singh]

Hi There,

Thanks for your time and providing the link.

I am aware, how to do it using Excel however just would like to find out the way to do it through vba.

Regards,

[humdingaling]

Please Login or Register  to view this content.

put this at the end of your code

if Followed Hyperlink theme does not exist
put under worksheet "home Work"

Please Login or Register  to view this content.

[BS Singh]

Thanks it worked using worksheet event method. You are STAR.

[humdingaling]

thanks for the rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.