How to bulk(automatically) change multiple Excel tables?

Question

excel

There are 70 excel tables in excel 2007 format. The tables have the same type of data (22 columns and 1000 rows, of which the first 8 rows are occupied by a header, the next 10-200 are data, the remaining rows are still empty).

Task:
Protect the header (first 8 rows) and columns A, H with a password (the same for each table)
Add data validation to some columns, starting from row 9 to row 1000)

I think to dig in the direction of the PowerShell script, but maybe there are options easier and more convenient?

Answer 1

no PowerShell needed. it's elementary in VBA. we sort through the files, open, do what is required, save, close.