Hyperlinks
How can I removeBig all the hyperlinks from an Excel document
|
Hyperlinks
On a sheet by sheet basis you could run this code
Sub DelHyperLinks() ActiveSheet.Hyperlinks.Delete End Sub If you want to iterate across all worksheets in a workbook try Sub DelHyperLinks() Dim wks As Worksheet For each wks in Worksheets wks.Hyperlinks.Delete next wks End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "BigDurk4x4" wrote in message ... How can I removeBig all the hyperlinks from an Excel document |
All times are GMT +1. The time now is 11:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com