I don't think you'll find any VBA code in programming group for file-open
passwords.

Passwords for internal protection is easy to crack but file-open are quite a bit
more difficult.

See these JE McGimpsey sites.

http://www.mcgimpsey.com/excel/removepwords.html

http://www.mcgimpsey.com/excel/fileandvbapwords.html


Gord Dibben MS Excel MVP

On Tue, 11 Dec 2007 10:18:55 -0800 (PST), "
wrote:

On Dec 11, 11:44 am, rwhite wrote:
Is there a way to "turn off" password protection so employees can not
password files and then leave?

I'm not sure if there's a way to disable that or not, but you can
crack those passwords fairly easily with a little code. Excel is NOT
a good place to secure data because of this. No matter how "tight"
you think you've set the security, it's pretty simple to work around
it. Just Google microsoft.public.excel.programming for "password
crack code" and you'll find lots of sample code.

Hope that helps and sorry to hear about unethical employees.

Cory