Depends upon how the hyperlinks were created, I believe.

It will not delete those you create with =HYPERLINK(..) Function

Just those created via right-clickhyperlink or EditPaste as Hyperlink.


Gord Dibben MS Excel MVP


On Wed, 18 Apr 2007 05:30:03 -0700, Gary''s Student
wrote:

Enter and run this small macro:

Sub qwerty()
For Each w In Worksheets
w.Activate
Cells.Hyperlinks.Delete
Next
End Sub


It will remove ALL hyperlinks in ALL worksheets.