If you want, I can:
Select the workbooks, enter a password, and the tool will apply it to all selected files. kutools for excel password work
One of the most advanced features is the ability to your password protection settings to a configuration file and import them into another workbook. If you manage a team of five analysts who all need identical protection rules on their reports, you can: If you want, I can: Select the workbooks,
( Password Input ) Enter Password: [ ] Confirm Password: [ ] If you want
: Provides "Encrypt Cells" and "Decrypt Cells" utilities to lock down specific data ranges within a sheet.