How can I password protect all word files in a folder?

Anonymous
2012-05-01T22:45:14+00:00

How can I password protect all word files in a folder? I know there is a macro for it I just cant write it. I can't get my head rounf visual basic I am only an admin who has to lock hundreds of files a month with the same password. Please someone give me a magic macro code and how to insert it.

I have been studying forums but I am no cleverer than 3 days ago. Tutorials don't help either.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Jay Freedman 208.1K Reputation points Volunteer Moderator
2012-05-02T14:44:24+00:00

> What am I doing wrong?

You missed this in my post:

>> change the path (be sure to keep the backslash at the end)

So you need to change this line:

     strFilePath = "C:\LOCKIT"

to this:

     strFilePath = "C:\LOCKIT"

The reason nothing was happening is that the Dir$() command takes that string and adds "*.doc*" to the end of it; without the backslash you're getting "C:\LOCKIT*.doc*" as the file to look for, and there is no such file (which would have to be in the root folder, C:).

Was this answer helpful?

1 person found this answer helpful.
0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-12-01T23:12:22+00:00

    Wow. That worked perfectly. Thank you. You've just saved me countless hours of work.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-11-28T17:22:01+00:00

    Hi there. I'm wondering if you can tell me how to modify this macro in two ways. First, I'd like to password-protect all of the files in a folder so that the only thing the password does is turn on the Track Changes (see snip below; I don't want recipients to be able to turn off the track changes). And, second, I'd also like to (separately) modify the macro to unprotect all of those same files in a folder. I'm using Microsoft 2010 on Windows 7.Tthanks.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-05-04T07:12:07+00:00

    Jay!! 

    Thank you!

    You did tell me , yes. I skipped over that detail again and again!

    The macro worked a treat!

    Looking into virtual basics now. Pretty exciting!

    Thanks again for taking the time to look!

    Was this answer helpful?

    0 comments