Thread: Removing hyperlink without removing the font settings /border sett
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
San San is offline
external usenet poster
  
Posts: 14
Default Removing hyperlink without removing the font settings /border sett
The below code removes hyperlinks
Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub
However it also removes the formatting(color/border) of the cell .
Any idea on how to protect the format of the cell
Reply With QuoteReply With Quote