Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Listing Documents with Passwords.
Jamie asked if it is possible to get a list of all passworded Word documents, or all documents using a particular password. The short answer is "No, Word doesn't have such a capability." Passwords are saved with a document, and if you don't know the password (or cannot guess a password), then you cannot open a document. Period.
The longer answer is that if you know what passwords you were personally most likely to use on a document, then you could write a macro that would attempt to open your documents using those passwords. The macro could follow these general steps:
Note that this approach will only work if you already know the possible passwords. For instance, if you have three or four passwords you typically use, then you could use these steps to test documents with those likely passwords. If a particular document doesn't use one of those passwords, then you are out of luck—the document will just be considered "unopenable" in step 3 and listed in step 6.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (10223) applies to Microsoft Word 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Word here: Listing Documents with Passwords.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Want to control the name and location of your document backup? Here are some ideas that may help.
Discover MoreImport a file from a source external to Word, and you can end up with a formatting nightmare. One big step is to remove ...
Discover MoreWhen working with lots of documents, you may have need from time to time to discover which of those documents contain ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-07-18 19:55:38
Michael
It seems so obvious after being laid out in a clear design.
What I'd like to know is how Step #1 works. Where do I find the info on how to open a file with a password, and how to detect that it did or didn't open?
I looked through the T of C (as well as possible--way too much to really scan) my new WordTips Macro book, and didn't see that covered.
Thanks
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: 
Comments