Excel 2007 : Opening Excel file after chosing specific answer in drop down list

Something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("N:N")) Is Nothing Then
        If UCase(Target.Value) = "Y" Then
            Workbooks.Open ("Filepath")
        End If
    End If
End Sub

This goes in the worksheet module, right click the sheet and press view code.

You need to change the filepath to the filepath of the workbook you want to open