I have a program that I've written in VBA (from Word) that opens and
modifies all of the Excel documents in a directory. The program hangs
when it reaches documents that have "Password to modify" set. These
documents don't have a "Password to open" set, so the check
"HasPassword" check returns false. I can't find any other check like
this (for the "Password to modify"), and am looking for help.

I don't want to get around the password, just to leave my routine and
move onto the next document. To restate, if I come across a document
that has a "Password to modify" set, I want to close it and move onto
the next document.

Thanks in advance.

Robert Brown