Unlocking pwd protected vba modules

[Guest]

I recenctly downloaded some ".xla" files from a friend and they the
modules within the ".xla" file were password protected and locked I have the
password and have been able to unlock the modules and examine the vba code.
However once I close the file and reopen it again the password protection is
still there,
even though I removed it commpletely. Whats even more strange is that when I
open them there are no visable work books or sheets and I have already
checked if they were hidden or somthing. Any Ideas on how to permentaly
remove the pasword protection from the ".xla" files ??

Thanks Dan Thompson

 

[Gord Dibben]

Dan

After accessing using the passwords, remove the "lock project for viewing"
checkbox and delete the passwords.

Save the file then.....CLOSE EXCEL......and re-open.

The closing is the trick.


Gord Dibben Excel MVP