Hyperlink

  • Thread starter Thread starter OSSIE
  • Start date Start date
O

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top