O
Otto Moehrbach
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
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