Module protection without password?

[patrussell]

Is it possible to have a protected VBA project without having a password?

I have a project that was written in Excel97 that is "locked" so that I cannot view the VBA code. I have tried two commercial tools for unlocking the project but both stated that the project was not password protected. I still cannot view the code and get the "project locked" message when I try.

I am trying to update the project to run in current versions of Excel but the MS fix requires exporting the importing the modules. As far as I know this cannot be done with the project locked.

Any ideas out there?

Thanks,

Pat Russell

 

[TonyJollans]

The answer to your question is: no.

Tek-tips does not condone password cracking, so no-one here is likely to help you, but removing VBA passwords is very easy and my suspicion is that the tools you have used may have been trying to break a workbook password (which has nothing to do with protection of VBA projects in Excel 97-format workbooks) rather than a VBA Project password.


Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[Andrzejek]

patrussell stated that "the project was not password protected" so he/she is NOT trying the password cracking and NOT violating Tek-Tips rules. The Project is locked somehow (not by password) and the question is: what are the other ways this could be protected?

Have fun.

---- Andy

 

[patrussell]

Andy is correct. I am trying to view the code in a project that states it is locked but does not appear to have a password.

Essentially I have an add-in that was programmed to extract data from a custom binary file for a system that is long obsolete. I would like to update the add-in to work with current versions of Excel. If there is a way to recompile it without unlocking it that would be fine as well.

Pat

Pat Russell

 

[strongm]

>stated that "the project was not password protected

No, they didn't. They stated that 2 commercial unlocking tools claimed that it was not password protected. This is not the same thing.

 

[TonyJollans]

So what happens when you try to view the code? Does it say "Enter password" or "Project is Locked"?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[combo]

I still ... get the "project locked" message ...

Most likely you have shared workbook. Make it exclusive and try to open the vba project again.

combo

 

[GlennUK]

Are you sure that it was written in Excel 97?

Is it maybe an addin written in Excel 5?

Cheers, Glenn.

Beauty is in the eye of the beerholder.