| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to convert hyperlinks to text
I have lots of hyperlinks in a worksheet, want to convert them all into plain
text. I couldn´t find an automatic way to do this other than with macros, does someone have a macro that do this? Thanks in advance Regards Emece. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macro to convert hyperlinks to text
Sub RemoveHyperlinks()
Selection.Hyperlinks.Delete End Sub Select the range that has the links (could be the entire sheet), Press Alt-F8 the run the macro. - John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text numbers to numbers | Excel Worksheet Functions | |||
| Convertin Text to numbers within a Macro?? | Excel Discussion (Misc queries) | |||
| How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
| Macro to delete and replace a text box | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Hybrid Mode
