Excel-hyperlinking between workbooks- close visited file when ret

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a collection of excel folders with a Master sheet contaning links to
other sub folders and files. I have links in each child file to return to
Master, but the .xls file remains open upon return to Master. Therefore, if
visit a dozen files there is a dozen visited files that remain open/active on
desk top -- how can I tag the "return" button to close the satellite file
once viewed and user selects "return to master" to Master via imbedded
hyberlink each page to return Master
 
Please help us understand. Why is it necessary to return to the master using
a hyperlink?

Why not just close the satellite file once you are done viewing it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

consolidate historical stock returns from multiple workbooks into oneworkbook 1
save and closing when hyperlink accessed 1
Template Folder with Excel Macros in Sub-Folders?? 0
How check if file to open is Excel or if Excel file is corrupt? 3
File does not close 2
xlApp.Quit - Doesn't Close Instance.... Any ideas? 14
Getting all open files in Excel 1
VBA assign macro to button from a different file (simple you'd thi 5

Back
Top