navigating and closing workbooks

[AmyTaylor]

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

[Leith Ross]

Hello Amy,

Here is the code your looking for...

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

For I = 1 To Hyperlinks.Count
If Hyperlinks(I).Range.Address = Target.Address Then
Beep
ThisWorkbook.Close
End If
Next I

End Sub

If you have questions you know where to reach me.

Sincerely,
Leith Ross