I have multiple workbooks (20+) located in a same file path folder that I would like add sheet protection to. Each workbook has only 1 sheet (sheet1) in it. Is there a way for a macro to run on each of the files in this folder and add worksheet protection to them rather that doing it manually? I would like the password for the sheet protection = md
I only need "Select Locked Cells" and "Select Unlocked Cells" checked for the properties.
Is this something that is doable?