Please Login or Register to view this content.
Can this code be written without using the book name? I'd like to have the hyperlinks there in such a way the book can be renamed without rewriting the hyperlink.
Please Login or Register to view this content.
Can this code be written without using the book name? I'd like to have the hyperlinks there in such a way the book can be renamed without rewriting the hyperlink.
Hi Raze,
Try using below formula:-
=HYPERLINK("["&A1&"]Protocol!F5","Protocol 001")
where A1 is Apartment_Planner.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
I see how this works. Is there no way to eliminate the book name altogether?
Book name is required to give the complete path for Hyperlink to work ..
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks