Hyperlinks

[dtaylor]

Hello All,
Is there a way to remove a hyperlink from multiple cells without having to select each cell, right click, select hyperling ...ect..

thanks

 

[Juan Pablo González]

ActiveSheet.Hyperlinks.Delete

or

Range("A1:C5").Hyperlinks.Delete

if you need a specific area.

 

[dtaylor]

thank you sir!

 

[dtaylor]

hi juan,
is also possible to remove all links in a workbook in a similar way?

dan

 

[Juan Pablo González]

Nope, you have to loop through the worksheets:

For each WS in ActiveWorkbook.Worksheets
WS.Hyperlinks.Delete
Next WS

 

[dtaylor]

Juan,
Forgive me for my bad verbage "links". I actually already created a loop to remove all hyperlinks for the file I was working with.

What I was trying to say is linked files... and not hyperlinks. I should of started
a new view.

Let me say this board is by far the best around!

Cheers to all who support!

Dan