hyperlink

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

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

Mike
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Will not auto open .jpg 1
Open specific hyperlink (accept) automatically in email with outlook 0
How to make an entire column of web addresses into hyperlinks? 2
Hyperlinks 2
Hyperlink to my macros in the same workbook 3
hyperlinks within Excel 3
Weird corruption of hyperlinks 7
Inserting a Hyperlink 1

Back
Top