protect/unprotect a VBA Project

[helmekki]

Hi all
Is there a way to:

unprotect a VBA project using code?

protect/unprotect a VBA Project using macro?

[mangesh_yadav]

something like this:


Sub ProtectSht(sht)
sht.Protect Password:=pwd, DrawingObjects:=True, contents:=True, Scenarios:=True
End Sub


Sub UnprotectSht(sht)
sht.Unprotect Password:=pwd
End Sub


Mangesh

[helmekki]

Thank u 4 your reply

i ment is there a vba code to remove protection from the protected vba project ?

sometimes vba projects are protected, so i am lookinf for a code to remove protection from the protected vba project ........

the code to remove protection might be placed in a workbook and be used to remove protection from a protected vba project that exists in a different workbook.

[helmekki]

any idea yet ????

[dominicb]

Good evening Helmekki

We are all pretty much aware that the protection for worksheets and structure is a little bit flimsy (to say the least!). However, the routines used to protect VBA routines and password protected files is a little bit more robust - but that is not to say it cannot be cracked, just not by a macro. If you need to open a password protected project you can buy specialist software to do so, or pay a service where you e-mail your file to a company and get it back several hours later unprotected.

It can be done using a hex editor, and if your file is not highly confidential I would be prepared to remove the password for you. No charge.

But it CANNOT be done from within Excel.

HTH

DominicB

[helmekki]

Ok dominicb, Thank u very much

I uploaded the addin that i would like to remove the password from the protected project.

pls see the attached addin.

Thank u

[dominicb]

Hi Hesham

Slight problem in that the program is not a VBA program, but has been written using VB (similar, but different). VB allows for standalone applications to be written and compiled modules to be used as excel add-ins, and compiled modules will look like mumbo jumbo (if you're not English you won't understand this term, but it means muddled up and confused!) and would not make sense.

So how can you tell if an add-in is compiled VB or standard VBA (which is compiled at run time)? Well, if you are prompted for a password, it is VBA. If the message is "This project is unviewable" it is compiled code. However, if you want to know how the program does what it does, have a quick look here for VBA code to do what this add-in does, and a bit of interesting information about how the password crackers work.

http://www.mcgimpsey.com/excel/removepwords.html

HTH

DominicB

[helmekki]

Thank u very much dominicb