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

Hello Guys,

Basically in one of my spreadsheets I have a drop down list with a simple yes and no answer. What I am looking for is when somebody selects "yes", another created excel documents loads up.

I can not seem to do this.

I have attached a blank file to show more. The purple box is where "yes" would be selected. I have also attached a second Excel document I would like loading up when "yes" is selected.

Thanks for any help.

Something like this:

Please Login or Register  to view this content.

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

Worked perfectly thanks very much.

Thanks for the help. Do you have any idea how I add the same option to a different cell?

I tried the below but it doesnt work.

Cheers

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 ("K:\email.xlsx")
End If
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("M:M")) Is Nothing Then
If UCase(Target.Value) = "Lapsed" Then
Workbooks.Open ("K:\email.xlsx")
End If
End If
End Sub

Like this:

Please Login or Register  to view this content.