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

--
Message posted from http://www.ExcelForum.com

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

Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Fanden >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a workbook in Excel 2K with 1000s of cut/pasted hyperlinks. I
> 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 such
> code and have tried to open the macro and fiddle w/it...I managed to
> LOCK my file...but have resaved it and can edit it now, so
>
> Any suggestions how to write/execute a macro to turn all hyperlinks
> off...?
>
> Fanden
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

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



--
Regards
Frank Kabel
Frankfurt, Germany


> I have a workbook in Excel 2K with 1000s of cut/pasted hyperlinks. I
> 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 such
> code and have tried to open the macro and fiddle w/it...I managed to
> LOCK my file...but have resaved it and can edit it now, so
>
> Any suggestions how to write/execute a macro to turn all hyperlinks
> off...?
>
> Fanden
>
>
> ---
> Message posted from http://www.ExcelForum.com/

Hi, Fanden. Try here:
http://www.mcgimpsey.com/macoffice/e...yperlinks.html

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
"Fanden >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a workbook in Excel 2K with 1000s of cut/pasted hyperlinks. I
> 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 such
> code and have tried to open the macro and fiddle w/it...I managed to
> LOCK my file...but have resaved it and can edit it now, so
>
> Any suggestions how to write/execute a macro to turn all hyperlinks
> off...?
>
> Fanden
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>