ClearHyperlinks in 2007

[MarkCBB]

HI there VBA Pro's

I wrote some code in excel 2010, as seen below.

Sub MyTest()
    Selection.ClearHyperlinks
End Sub

However when I run the code in Excel 2007 it does not work. what code can I use in 2007 to achieve the same result?

 

[VoG]

Try

Sub MyTest()
    Selection.Hyperlinks.Delete
End Sub

 

[MarkCBB]

Thanks VoG,

That works perfectly, I just saw that the ClearHyperlinks button doesn't exits on 2007, must be a new option on 2010.

Thanks again,

Regards,
Mark