However, everytime the delete happens an error message appears saying
that: "Data may exist in the sheet(s) selected for deletion. To
permanently delete the data, press Delete."

How can I automate or code for the macro by-pass or click the delete
button so that my Macro doesn't stop running?