Thread: Converting Text to a hyperlink
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Converting Text to a hyperlink
If you copy a hyperlink and then paste/special/value somewhere else, the copy
will be "cold" (un-clickable). To make the hyperlink "hot" just select the
cell, touch F2, then touch ENTER.
--
Gary''s Student - gsnu2007


"Darin Kramer" wrote:



But.... when I copy and paste values(as I'd like to move that cell to
another book), Excel forgets that it is a hyperlink - ie clicking it no
longer launches email...

Ideas...?

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***

Reply With QuoteReply With Quote