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

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

On Thu, 6 Oct 2005 15:05:05 -0700, Dan Thompson
wrote:

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