Hi, I alter my statement, it doesnt work,


At right I have a sheet for monthly income from investments delivering such,
at left I want the sheet showing annual incomings outgoings, from where I will source that data.
At left I click the link in the index page for annual IN OUT 2022, and horror, the right hand one becomes that sheet.


How do I make the click on sheet link alter the window the click is made in, and not alter the window at right ?
They are one of the same workbooks.


The old method had a read only and one could do this above and it only operated on the left workbook, it didnt keep altering the sheets at right.


If this is Excel thinking they will make changes for the better, this is a nightmare, links in left workbook alter sheets in right workbook.


So is there a way to limit the action to just the left workbook when I click on the hyperlink in that workbook to the sheet in the index page ?


DBenz