Thread: Macro to convert hyperlinks to text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default 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 With QuoteReply With Quote