There are couple of ways to unlock vba projects... Unfortunately I can't
give it to you for obvious reaons. but if you are really sincere of what you
saying then send the sheets to me i'll unlock it and send them back to you.

is up to you.







"Terence E Roberts" wrote in message
...
I have had some complicated spreadsheets handed down to
me, but unfortunately the vb code is locked, the author is
no longer with us and no-one knows the password.

Is there any way I can write a macro to find out and
unlock this password.
I know the maximum number of password characters is 32 and
given there are 250 odd ASCII characters, the loop will be
pretty long, but the prospect of attempting to redo these
sheets is pretty dire!

All help appreciated

TER