Option to Exit Macro Via Message Box

Hello, I am wondering how to write a code that checks the number of workbooks open and, if it is more that one, pops up a message box giving the option to exit the macro by pressing no or cancel. I have successfully gotten the message box to show but cannot get the additional NO button to work correctly. Thank you!