Deactivate ALL hyperlinks-VBS?

[Fanden]

I have a workbook in Excel 2K with 1000s of cut/pasted hyperlinks.
want to deactivate them all to reduce the file size.

FAQs says to use a VBS Macro but I dont have a clue how to write suc
code and have tried to open the macro and fiddle w/it...I managed t
LOCK my file...but have resaved it and can edit it now, so

Any suggestions how to write/execute a macro to turn all hyperlink
off...?

Fande

 

[Don Guillett]

copy paste this to a module in your workbook>then alt f8>this
workbook>double click.

Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub

 

[Frank Kabel]

Hi
Use the following macro to remove hyperlinks of a chosen selection
Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub

To use this code try the following / to get started with macros have a
look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Anne Troy]

Hi, Fanden. Try here:
http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->