Does anyone know of some code I could use to close the file whenever I navigagate away via a hyperlink.

For example: workbook1 links to workbook2. In workbook2 you can navigate back to workbook1 using a hyperlink, however workbook2 is still left open.
I want workbook2 to close whenever you go back to workbook1.

Can anyone help ?!

Thanks

Amy xx