Protect multiple worksheets VBA

[dinhaopoto]

Hi everyone,

I need to protect all worksheets within multiple workbooks. No password needed to open to workbook, but I would like a password to make any changes on the actual worksheets. There are over 2,000 workbooks with multiple worksheets that need to be protected. The workbooks are a mix of .xls and .xlsx.

Can anyone help? I dont want to open each workbook to protect them individually as it would be extreeeemelly time consuming. =(

Any help is appreciated!!