Mass Removal of Hyperlinks

[Jamie]

Hello,

Hundreds of cells in a spreadsheet I use have mysteriously
had hyperlinks added to them. (There were hyperlinks in
some cells but I don't know how the rest of them got
there.)

My question is: Is there a way to "mass remove" all of
these hyperlinks.

TIA,

Jamie

 

[Ron de Bruin]

Hi Jamie

You can run this macro to make text of all hyperlinks on the activesheet

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run

 

[Jamie]

Ron,

Thank you very much.

Jamie

-----Original Message-----
Hi Jamie

You can run this macro to make text of all hyperlinks on the activesheet

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jamie" <[email protected]> wrote in

message news:[email protected]...