Morning all,

I have a number of documents that should be password protected but I can see that many of them aren't. Is it possible to use Power Query to identify the protection status (Workbook level) of each of them? In terms of an output, a simple two column table of filename and protection status (TRUE/FALSE - or whatever the standard PQ definition is) is all I need. They are all stored in the same folder structure.

Regards,

Snook