Password protect all files in a folder

B

Boss

Hi,

I wish to develope a code which can go to a folder and password protect all
the files. Is this possible... please advise.

Thx!
Boss
 
J

James Igoe

Yes.

1. You start an excel application object
2. Iterate through directory listing, opening each file
3. setting password-preotection, resaving and closing file
4. opening next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skip password protect files and open non protected files 5
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Detect macro in excel file without opening it 6
Open Workbooks and Password Protect all Worksheets 1
Different password for different worksheet " Help !" 1
Novice - using macro to protect with password 10
macro to password protect exel file 1
Protecting Sheet 2

Top