ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I disable all Hyperlinks in Excell 2000 (https://www.excelbanter.com/excel-discussion-misc-queries/63831-how-can-i-disable-all-hyperlinks-excell-2000-a.html)

penguino18

How can I disable all Hyperlinks in Excell 2000
 
I am trying to disable all hyperlinks without having to do each one
individually. Is there a way to do this?

Don Guillett

How can I disable all Hyperlinks in Excell 2000
 
try this

Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub

--
Don Guillett
SalesAid Software

"penguino18" wrote in message
...
I am trying to disable all hyperlinks without having to do each one
individually. Is there a way to do this?





All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com