Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove blue hyperlink line
Excel XP & Win XP
I have a list of hundreds of hyperlinked cell entries. I want to remove the hyperlinks by code. When I manually scroll to one of these cells, right-click, and select Remove Hyperlink, the hyperlink is gone. However, there remains a blue line at the bottom of the cell that is not as long as the column is wide, so it's not a border and it's not an underline. My question: How do I remove that blue line, manually or by code? Once I know how to do it manually I can record a macro and get the code. Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove blue hyperlink line
go to tools/autocorrect options and uncheck show autocorrect options buttons and
see if that's what you want -- Gary "Otto Moehrbach" wrote in message ... Excel XP & Win XP I have a list of hundreds of hyperlinked cell entries. I want to remove the hyperlinks by code. When I manually scroll to one of these cells, right-click, and select Remove Hyperlink, the hyperlink is gone. However, there remains a blue line at the bottom of the cell that is not as long as the column is wide, so it's not a border and it's not an underline. My question: How do I remove that blue line, manually or by code? Once I know how to do it manually I can record a macro and get the code. Thanks for your time. Otto |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove blue hyperlink line
Gary
I appreciate the help but it didn't anything about the blue line. Thanks anyway. Otto "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... go to tools/autocorrect options and uncheck show autocorrect options buttons and see if that's what you want -- Gary "Otto Moehrbach" wrote in message ... Excel XP & Win XP I have a list of hundreds of hyperlinked cell entries. I want to remove the hyperlinks by code. When I manually scroll to one of these cells, right-click, and select Remove Hyperlink, the hyperlink is gone. However, there remains a blue line at the bottom of the cell that is not as long as the column is wide, so it's not a border and it's not an underline. My question: How do I remove that blue line, manually or by code? Once I know how to do it manually I can record a macro and get the code. Thanks for your time. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove watermarks, but keep blue page-break indicators. | Excel Discussion (Misc queries) | |||
How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
Limited Page Printing problem; Blue Dashed Line Delineating End Of Document ? | New Users to Excel | |||
Page Break Blue Line Broken! | Excel Discussion (Misc queries) | |||
a blue line running horizontally through a few cells what is it | New Users to Excel |