A dialog stops my macro

Hi guys.
First here is my code

Please Login or Register  to view this content.

When the namesheet2 is missing in the workbook, a "Select Sheet" message appears stoping my macro. How I can to pass this message in the macro?
The only way is pressing [ESC] for every cell.
Another sugestion please?

Thanks for your response Ray.
When a workbook referenced in a formula is missing, excel shows a "Select workbook" dialog box. This can be passed by Application.DisplayAlert = False.
But, if this workbook is not missing, but the referenced sheet is missing, excel shows a "select sheet" dialog.
How can this be passed?