VBA code to password protect all excels files in a folder

Hi Friends,

I appreciate for your help in advance.

I have a folder that has around 8 files and i need to password protect these files everyweek and send it to my manager. Please help if i can password protect all these files in one shot.

Steps to be included in the macros are as follows.

Prompt you to select a folder
Prompt you to select PROTECT or UNPROTECT action on the files in that folder
Prompt you to enter a password to use
Process all the files in that folder
Give a count of how many files were affected

Thank you in advance.