close

I have lots of hyperlinks in a worksheet, want to convert them all into plain
text. I couldn´t find an automatic way to do this other than with macros,
does someone have a macro that do this?

Thanks in advance

Regards
Emece.

Sub RemoveHyperlinks()
Selection.Hyperlinks.Delete
End Sub

Select the range that has the links (could be the entire sheet), Press
Alt-F8 the run the macro.

- John

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄