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

go to tools/autocorrect options and uncheck show autocorrect options buttons and
see if that's what you want


--


Gary


"Otto Moehrbach" <[email protected]> wrote in message
news:[email protected]...
> 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
>

Gary
I appreciate the help but it didn't anything about the blue line.
Thanks anyway. Otto
"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:[email protected]...
> go to tools/autocorrect options and uncheck show autocorrect options
> buttons and see if that's what you want
>
>
> --
>
>
> Gary
>
>
> "Otto Moehrbach" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>