Hyperlink

[OSSIE]

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

 

[David McRitchie]

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