ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the Hyperlink in a cell (https://www.excelbanter.com/excel-programming/280532-changing-hyperlink-cell.html)

Michael Kintner[_2_]

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

Thank you in advance for anything.
Mike



Tom Ogilvy

Changing the Hyperlink in a cell
 
Turn on the macro recorder while you do it manually, then look at the code.
It will give you the syntax you need.

--
Regards,
Tom Ogilvy

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

Thank you in advance for anything.
Mike





Michael Kintner[_2_]

Changing the Hyperlink in a cell
 
Thank Tom!! (smile)


"Tom Ogilvy" wrote in message
...
Turn on the macro recorder while you do it manually, then look at the

code.
It will give you the syntax you need.

--
Regards,
Tom Ogilvy

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

Thank you in advance for anything.
Mike








All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com