spar-kle
asked on
How can I create a hyperlink using VBA and Windows navigation?
I would like to create a hyperlink, say in cell A1, by running a macro that opens a Windows navigation panel.
In principle it would be exactly like right clicking a cell and clicking the hyperlink option.
I would like the macro to specify the cell that the hyperlink would be added to.
In principle it would be exactly like right clicking a cell and clicking the hyperlink option.
I would like the macro to specify the cell that the hyperlink would be added to.
ASKER
Thanks Shuns. I can see that will add a hyperlink according to the hard coding. However I want to click on a button ...open a navigation pane ...navigate to a file click on the file and create a link in a cell designated by the code.
ASKER
Sorry "Shums"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's excellent.
Thanks Shums
Thanks Shums
You're Welcome! Please to help
Something like this:
Open in new window
It will create hyperlink in Cell A1 of Sheet1 to go to Cell A5Create-Hyper-Link.xlsm