Hello.
I have a query regarding using Hyperlinks in Excel. I have created an Excel master file in Which i have linked multiple Excel Sheets with help of Hyperlinks. I have also created Hyperlinks in those multiple Excel sheets to return back to Original master Excel Sheet. The Hyperlinks work fine. But is there a way in which if i click return to Master file. the Excel sheet redirects me to the original Excel sheet & simultaneously closing the Linked Excel Sheet.
Hi,
When you say 'sheet' I presume you mean 'workbook'?
When you link to other sheets, I'm assuming you are linking to sheets in other workbooks?
So when you click a link in the Master WB, it opens another WB?
In which case you could just use a little VBA to close the workbook you just opened. The Master WB remains open.
See attached.
Phil
