Unlock a vb code of a workbook

[Manos]

Dear All

I have a workbook which was locked and i managed to unlock it. But the
woorkbook contains a visual basic where the code is locked and i can not
make any changes in some ranges.
There is any way to unlock the code of the workbook?

Thank in advance
Manos

 

[Guest]

Any excel code in a vba module - an xla - can be examined - the encryption is
not strong. Have a search on googel for Excel password crackers and you'll
see some shareware and some paid for software. Be aware that this may
conflict with intellectual property law in your country,

 

[Manos]

The problem is that I have used such programs but all they give that the
excel is not protected, but when I am trying to access the code with Alt+F11
then it ask for password in order to open the code.

Any ideas?

Thanks in advance,

Manos

 

[Guest]

You are probably using a utility to unlock locked worksheets - not locked vba
code. Use the correct tool and you'll be able to view the code.