I want to click on a hyperlink on sheet1 and have it open a hyperlink on
sheet2, rather than just going to the cell reference on sheet2.

I can't work out how to do it. Does anyone have any ideas?

AO