Mass Removal of Hyperlinks
 

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

Mass Removal of Hyperlinks
 

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
InsertModule 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" wrote in message ...
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

Mass Removal of Hyperlinks
 

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
InsertModule 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" wrote in
message ...
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


.