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

Top