Hello all.
I have alot of shapes on my worksheet which i have tagged with a hyperlink.
What i would like to do is have the link changed based on a cell value.
In my workbook i have a sheet called 'Data' and cell C2 will either have the value 'Earlies', 'Lates', 'Nights'
If on my 'Data' sheet i put column heading of 'Earlies', 'Lates', 'Nights' in cells B3:D3
Cells A3:A6 i will put the title of what e.g. Apples, Pears, Grapes
B4:D6 will contain a list of my hyperlinks as text e.g. C:\Earlies Gr.xlsm
I would then like a shape to have the hyperlink based on the cell value of C2
If C2=Earlies
Button(shape) Grapes would open C:\Earlies Gr.xlsm
Button(shape) Apples would open C:\Earlies Apples.xlsm
Thanks for any help you can provide
I have alot of shapes on my worksheet which i have tagged with a hyperlink.
What i would like to do is have the link changed based on a cell value.
In my workbook i have a sheet called 'Data' and cell C2 will either have the value 'Earlies', 'Lates', 'Nights'
If on my 'Data' sheet i put column heading of 'Earlies', 'Lates', 'Nights' in cells B3:D3
Cells A3:A6 i will put the title of what e.g. Apples, Pears, Grapes
B4:D6 will contain a list of my hyperlinks as text e.g. C:\Earlies Gr.xlsm
I would then like a shape to have the hyperlink based on the cell value of C2
If C2=Earlies
Button(shape) Grapes would open C:\Earlies Gr.xlsm
Button(shape) Apples would open C:\Earlies Apples.xlsm
Thanks for any help you can provide