Hello,
I have a 'Vehicle Information'! sheet that has hyperlinks to the vehicle sheets. When I change the name of the vehicle sheets the reference is not valid for the hyperlinks. Is there a way to maintain the hyperlinks on a worksheet tab name change?
Thank you in advance for your help
Can't do anything with a password protected sheet. Please either unprotect the sheet and reattach, or provide the password. Thanks.
Sorry just click on the 'Unprotect' red button on the 'Vehicle Information' sheet.
The password is "password" if that doesn't work.
Place this in B10 and drag it across,Formula:
Please Login or Register to view this content.
--------or-----------
Since you are already using VBA, you can use the selection change event.
-
UseSlectionChange.jpg
Please Login or Register to view this content.
Last edited by davesexcel; 11-03-2018 at 08:34 AM.
Thanks Dave I tried the formula method but it says reference not valid.
Your first vehicle sheet name does not match the cell
Yes that was why I started the post. I would like the hyperlinks to maintain when I change the vehicle sheet names by the range B4:I4 so it is a dynamic reference please.
I used named range to accomplish this thanks guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks