Unlocking pwd protected vba modules
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
|