Hyperlink

[Mike]

Is there anyway I can remove Hyperlink from the whole
spreadsheet at the same time.

Mike

 

[Dave Peterson]

Select your range to clean up (ctrl-A will get the whole sheet).

Hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window
type in
selection.hyperlinks.delete
and hit enter.

 

[David McRitchie]

Hi Mike,
Looks like the same question posted elsewhere and answered
by J.E. McGimpsey. If not my own choice would be to just let
the hyperlinks get generated -- I find them usually helpful --
and then eliminate the ones you don't want based on selection.
Use Ctrl+A to select entire sheet to eliminate all hyperlinks with
the macro. The macro I would use can be found at
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperLinks

Sub DelHyperLinks()
Selection.Hyperlinks.Delete
End Sub