Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop Excel from underlining hyperlinks?
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. *** |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop Excel from underlining hyperlinks?
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. -- Gary''s Student - gsnu2007 " wrote: 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. *** |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to stop Excel from underlining hyperlinks?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I stop excel from automatically making hyperlinks | Excel Discussion (Misc queries) | |||
How can I stop my Excel hyperlinks from reassigning their destina. | Excel Discussion (Misc queries) | |||
How can I stop Excel 2003 from changing my hyperlinks on close? | Excel Discussion (Misc queries) | |||
stop Excel hyperlinks | Excel Discussion (Misc queries) | |||
How do I stop automatic hyperlinks? | Excel Discussion (Misc queries) |