How to stop Excel from underlining hyperlinks?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

baobob@my-deja.com - 21 Oct 2007 07:57 GMT

In Excel 2002 10.2614.2625, I have a worksheet in which I never want
to see the contents of any cell underlined, ever.

To implement this, I can press Ctrl-A to hi-lite the sheet, then Ctrl-
U (either once or twice, depending on whether cell I'm sitting on is
already undelined) to kill all underlines thruout the sheet.

Henceforth, Excel behaves very well and doesn't underline new input--
even URLs, which is nice.

BUT, it always undelines newly-inputted hyperlinks. For example, if I
enter =HYPERLINK(<something>) into a cell and press Enter, the thing
is then underlined, and I gotta de-underline it. And I've got hundreds
of the little buggers.

Is there any way to stop Excel from doing that?

Thanks much.

***

Reply to this Message

Gary''s Student - 21 Oct 2007 12:44 GMT

Insert the following macro in you worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.Underline = xlUnderlineStyleNone
End Sub

This will prevent underlining from either =HYPERLINK() or Insert >
Hyperlinks...

REMEMBER: the worksheet code area, not a standard module.

Signature

Gary''s Student - gsnu2007

> In Excel 2002 10.2614.2625, I have a worksheet in which I never want
> to see the contents of any cell underlined, ever.
[quoted text clipped - 16 lines]
>
> ***

Reply to this Message

Dave Peterson - 21 Oct 2007 13:58 GMT

You can change the Hyperlink Style, too.

Format|Style|Choose hyperlink in the dropdown box.
Click the Modify button
On the Font tab, change the underline from Single to None.

This style is associated with the workbook. You'll have to do the same thing
for each workbook where you want this behavior.

> In Excel 2002 10.2614.2625, I have a worksheet in which I never want
> to see the contents of any cell underlined, ever.
[quoted text clipped - 16 lines]
>
> ***

Signature

Dave Peterson

Reply to this Message

baobob@my-deja.com - 22 Oct 2007 16:53 GMT

Gary's + Dave:

Thanks so much for replies.

Dave: Are you telling me that I've been using Excel for 20+ years and
NEVER REALLY USED the Style dialog? That is truly sick.

And in fact my next question was going to be how to set font and other
defaults, in general. I was too narrowly focused on Tools / Options
only all these years.

So thanks again. Ya just freed the slaves.

***

Reply to this Message