Setting Hard Hyperlink in cell

[Michael Kintner]

How can I set the hard hyperlink in a cell or change it? I can do it
mannually though Insert Hyperlink, but how can I do it via programming
function?

Thank you in advance for anything.
Mike

 

[David McRitchie]

Hi Mike,
If you want a hyperlink you can change you might want to consider
using the HYPERLINK Worksheet Function.

As far as changing the Inserted Hyperlink such as changing
the prefix to another prefix:
http://google.com/groups?as_umsgid=e6#fCptFCHA.2280@tkmsftngp12

Other things you might want to do with Hyperlinks can be seen in
http://www.mvps.org/dmcritchie/excel/bujildtoc.htm