View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default


Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub
--
Don Guillett
SalesAid Software

"Fulchp47" wrote in message
...
I have several hyperlinks to graphs within an Excel document, just on
seperate tabs. Now when trying to clear the contents and just type text

into
that cell, it will not release the hyperlink. It only allows me to delete
the entire row or column, which I don't want to do because I would have to
re-create the entire document.
How can I simply break the hyperlink within the Excel sheet?