Hyperlinks - identifying source in destination sheet

U

UniDave

Just getting back into Excel after long time away so a bit rusty

I have built a macro that will create hyperlinks for many rows o
results and the destination cells or ranges may be hyperlinked severa
times, dependant on the results.

Can anyone tell me whether it is possible to create icons in th
destination sheet/file which, when clicked, will take the user back t
the cell or range that holds the hyperlink?

Putting the icon issue to one side, can the destination sheet revea
which file/sheet is hyperlinking to it?

Thanks

FOR THOSE INTERESTED THE WORK I AM DOING CONCERNS MAPPING RISK SCORE
INTO A HEAT MA
 
Top