| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove multiple hyperlinks from a document
Please can anyone help me with this question
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove multiple hyperlinks from a document
select the range with the links (the whole worksheet??)
hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete Azra wrote: Please can anyone help me with this question -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove multiple hyperlinks from a document
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete End Sub -- Don Guillett SalesAid Software "Azra" wrote in message ... Please can anyone help me with this question |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove multiple hyperlinks from a document
Thank you. This helped me clear all my links as well. The assistance is
much appreciated. -- Pam Davis, SAIC Contractor Center for Information Technologies National Institutes of Health "Dave Peterson" wrote: select the range with the links (the whole worksheet??) hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete Azra wrote: Please can anyone help me with this question -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to update hyperlinks through multiple sheets but can't | Excel Worksheet Functions | |||
| Multiple hyperlinks in a single cell | Excel Discussion (Misc queries) | |||
| how do I remove multiple pagebreaks in an excel document in one g | Excel Discussion (Misc queries) | |||
| Remove multiple hyperlinks in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
| Remove Second Language From my Document | Excel Discussion (Misc queries) | |||
Linear Mode
