How to search for only protected files?

  • Thread starter Thread starter Philip J. Koenig
  • Start date Start date
P

Philip J. Koenig

At a company where an employee has recently left we need to find
all workbooks that are password-protected.

I don't see any built-in way to do this and I haven't had much
luck searching usenet and the web either, with the exception of
the following usenet post from Dave Peterson which might help
but it requires VBA which I know nothing about:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&[email protected]


Any other ideas?

(PS: currently they are using Excel 97)



--
* Few people are capable of expressing with equanimity opinions which *
* differ from the prejudices of their social environment. Most people are *
* even incapable of forming such opinions. -- Albert Einstein *
* *
* To send email, remove numbers and spaces: pjkusenet64 @ ekahuna27 . com *
* Simple answers are for simple minds. Try a new way of looking at things. *
 
Hi

I have a file that basically does what you want . Email me and I will send
it to you.

HTH

KenM
 
Back
Top