Excel VBA - protect multiple worksheets within multiple workbooks using same password

[lancer008]

Hi VBA Gurus,

I have more than 100 excel workbooks in a folder that I need to open each workbook individually and protect multiple worksheets within a workbook using same password.

I would greatly appreciate it if someone could share VBA code...

thanks
L

 

[kweaver]

I don't know how to do this in VBA, especially with 100 workbooks.
However, ASAP Utilities (free) has an option where you can select numerous sheets in 1 workbook and password them all with the same password.
Might give you a start.