excel learner
asked on
Hyperlinking name range
Dear experts,
I have workbook in the one of the sheets i have in column A list of name ranges
IS there a way i can hyper link the name ranges in column A in sheet 'name range' to the range where it refers to
for example in sheet 'name range'
column A cell A5 value is 'BSM_1_1'
Coumn B cell B5 i have the range value is ='xyz'!$C$70
Now i want a macro which will create a hyperlink under cell B5 which when i click will take me to the range where it referred.
IF a solution can be made available whereby if a macro is provided which create a list of all name ranges, specificy the name and hyper link it automatically, will also be a nice one.
Thankyou
I have workbook in the one of the sheets i have in column A list of name ranges
IS there a way i can hyper link the name ranges in column A in sheet 'name range' to the range where it refers to
for example in sheet 'name range'
column A cell A5 value is 'BSM_1_1'
Coumn B cell B5 i have the range value is ='xyz'!$C$70
Now i want a macro which will create a hyperlink under cell B5 which when i click will take me to the range where it referred.
IF a solution can be made available whereby if a macro is provided which create a list of all name ranges, specificy the name and hyper link it automatically, will also be a nice one.
Thankyou
ASKER
Siddarth thank you for your comment.
Let me put the question a little differently.
If i have value in cell A1 in sheet 1, ='xyz'!$C$70
and i f i have a sheet XYZ in the same work book,
then is it possible to put a hyperlink under ='xyz'!$C$70
and when i click on it will go to cell c70 in sheet xyz.
thank you,
Let me put the question a little differently.
If i have value in cell A1 in sheet 1, ='xyz'!$C$70
and i f i have a sheet XYZ in the same work book,
then is it possible to put a hyperlink under ='xyz'!$C$70
and when i click on it will go to cell c70 in sheet xyz.
thank you,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jkpieterse,
thank you for the formulae, the hyperlinking is activated, but when i click i got the error message as appearing in the attached.
kindly help
Thank you
excel-security-message.doc
thank you for the formulae, the hyperlinking is activated, but when i click i got the error message as appearing in the attached.
kindly help
Thank you
excel-security-message.doc
I have seen that happen before, but not with links internal to Excel. I'm sorry I do not know (at the moment) if you can suppress that message.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sid