VBA required to delete some rows in each workbook

That's no problem. Pleased to help.

You need to resolve the privacy warning on your workbooks when they are closed, read the link

Remove The Personal Information Warning

That looks like an issue with your Excel application. I have opened one of your sample workbooks and the boxes are white and clickable