Macro Code to Encrypt Multiple Excel Files in Folders and Subfolders

**ali_1989** · 01-04-2014, 10:11 AM

Hello Guyz,
I need a help from those who are good at macro codes. Recently i decided to protect the excel files in my office. But its a tedious task to individually add password protection to the 1000's of excel files located in different folders and sub folders. There i started to search for suitable macro codes. And my search ended in getting a code similar to what i need. But i need to modify this code to suit it for my purpose.
What I require :-
1. The code should encrypt the files. The current code i recieved will only protect the files from editing. For me, files should not be viewed by anyone else with out entering the password. I want to encrypt the files
2. I want the macro code to search for excel files in folders and Subfolders. The current code only protect those files in the folder i selected.

So can anyone modify the following code to meet my purpose. It will be a great for me.

The code given below will :-
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 with options above
Give a count afterward of how many files were affected

Please Login or Register  to view this content.

**LJMetzger** · 01-04-2014, 12:53 PM

For a slightly different approach take a look at Open-Source TrueCrypt^tm or one of the many competing products. You have to enter a password before you can access any of your encrypted data. See http://www.truecrypt.org/

I do volunteer work preparing Tax Returns for Senior Citizens through AARP Tax Aide. AARP Tax Aide has used TrueCrypt to store encrypted data on their computers for several years with IRS approval. No NSA jokes please.

Lewis