Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mass edit Hyperlinks | Links and Linking in Excel | |||
Need LV MASS formula | Excel Discussion (Misc queries) | |||
bulk removal of hyperlinks | Excel Discussion (Misc queries) | |||
Mass removal of green triangles | Excel Discussion (Misc queries) | |||
mass changes in formulas | Excel Programming |