Mass Removal of Hyperlinks

J

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
 
R

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
 
J

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
Click to expand...
message news:[email protected]...
 
Top