hyperlink

M

mike

Is there anyway that I can remove hyperlink from an entire
spreadsheet at the same time.

Mike
 
J

J.E. McGimpsey

one way:

type ALT-F11 to enter the VBE. Choose View/Immediate Window. Type or
paste

ActiveSheet.Hyperlinks.Delete

and type Enter.

Type ALT-F11 to return to XL.

You can use this macro if you have to do it many times:

Public Sub RemoveAllHyperLinks()
ActiveSheet.Hyperlinks.Delete
End Sub

If you want to combat the insertion of automatic hyperlinks, in
XL02/03 uncheck the checkbox in Tools/AutoCorrect. In previous
versions you can use the technique shown here:

http://www.mcgimpsey.com/excel/nohyperlinks2.html
 
Top