question about Msgbox vbOKCancel

[Barbarte]

Hi guys,


I've created a routine that starts with a message box saying the following:

"Please Confirm 'DTmacTest.xls' is the ONLY open Excel workbook"

So I have an "OK" button and a "Cancel" button.

but no matter which one I press, it runs the routine.

How do I assign the cancel button to stop the routine when it's pressed?

thanks,

Paul.

 

[Barbarte]

Paul

You could just use IF to test for the cancel button, and exit the routine if Cancel's been pressed:

If MsgBox("Please Confirm 'DTmacTest.xls' is the ONLY open Excel workbook", vbOKCancel) = vbCancel Then Exit Sub
Rest of your code here...........

thanks .
should have thought of that.