Password protect multiple excel sheet saved in same location by using VBA

[AyeshaM]

HI there,
I have 96 excel files saved in same location and same folder ( C Drive) . I would like to password protect these 96 files with the same password. Is there any VBA code that some one could share ( could you please explicitly mention what needs to be updated in that code for it to work). This would really save lot of my time. Thanks.

 

[Micron]

Examples and tutorials can be found for just about any question if one does a web search on the topic. This is one of them. Rather than us re-create the wheel, perhaps you can make this work:

https://www.wallstreetmojo.com/vba-protect-sheet/

 

[Joe4]

Welcome to the Board!

It sounds like you want to protect workbooks, not worksheets, so I don't think that previous link is what you want.
Also, you need to loop through all the files in a folder.

Have a look here: VBA Protect/Unprotect Workbook (Excel File)

There are two sections that you will want to focus on:
"Protect All the Closed Workbooks from a Folder"
That has most the code you need, except it does not show how to protect it using a password.
Have a look at the following section for that tweak:
"Protect a Workbook with Password"

 

[Micron]

Yes, perhaps. Question title says "sheet", post says "files". Not really consistent or clear to me.