Hi,

You only need to check the No button

response = MsgBox("Have you opened 1244.xls?", vbYesNo, "Your Title")
If response = vbNo Then Exit Sub

Mike

"Wu" wrote:

In my marco, I want to show a message box to ask " do you have open the
1244.xls file" and to show two button " yes" and "no" for user select.

If user select "yes", my marco will go on,

select "no", it will quit the marco