hello
is there a way to write in a cell when you have a hiperlink , and how
if you make a mistake remove the hyperlink on hte main sheet
Thanks


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=528346

Hi OSSIE,
On way would be to use HYPERLINK Worksheet Formulas

Once you have inserted an object hyperlink, you can update the display
text without the hyperlink being updated. The safest way would be to
use Ctrl+K to modify the hyperlink where you can see both the
text to display and the hyperlink address.

If you want to reenter the hyperlinks with the same content of the cell you
can take a look at some of the macros on
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"OSSIE" wrote in message
...

hello
is there a way to write in a cell when you have a hiperlink , and how
if you make a mistake remove the hyperlink on hte main sheet
Thanks


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=528346