MrExcel Message Board


Go Back   MrExcel Message Board > Question Forums > Excel Questions

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

Reply
 
Thread Tools Display Modes
Old Mar 30th, 2004, 06:06 PM   #1
fzhou
 
Join Date: Nov 2003
Posts: 118
Default Prevent hyperlink from changing color after click?

I have a Table of Content which has links help users navigate through the file. I also need to print the file in color. But after click on the link, the link will change color. I want it to stay in blue no matter whether I click it or not. I am not sure if there is a way to do it.

Thanks in advance.
fzhou is offline   Reply With Quote
Old Mar 30th, 2004, 06:42 PM   #2
Mat
 
Mat's Avatar
 
Join Date: Sep 2003
Location: Montréal, Québec
Posts: 489
Default Re: Prevent hyperlink from changing color after click?

With XL 2000 :

Go to FORMAT / STYLE / in "Style Name" choose Viewed Link.. and modify the police..

Well, it may be not exactly this because I use XL in french and so my traduction may be a little bit wrong. Anyway it should help you!

Hope this helps,
__________________


Mat
<hr align=left color=red width=400 size=1>"I will not compromise my ideals, music or nap schedule" - Trent Lane
Mat is offline   Reply With Quote
Old Mar 30th, 2004, 06:51 PM   #3
fzhou
 
Join Date: Nov 2003
Posts: 118
Default Re: Prevent hyperlink from changing color after click?

Hi Mat, it works.

Meci beaucoup.
fzhou is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT +1. The time now is 08:06 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All contents Copyright 1998-2009 by MrExcel Consulting.