Forum

Notifications
Clear all

Hyperlinks

2 Posts
2 Users
0 Reactions
79 Views
(@shantanu-kulkarni)
Posts: 1
New Member
Topic starter
 

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. 

query.jpg

 
Posted : 29/07/2018 1:58 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

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

 
Posted : 30/07/2018 11:09 pm
Share: