Unprotect Visual Basic Editor

Hi All,

Hope this message finds you well.

Is it possible to instruct a macro to unlock vba in another workbook that has been password protected?

I know the password - this is not a hack!

I thought something along the lines of: vbproject.unprotect password:="Password1"

Is this possible?

Thanks,

Just out of interest, what's the purpose of unlocking the VBA?

BSB

You could use SendKeys to simulate you opening the VBE and removing the password.

Personally I would write code that replaces the current version of the file with the update version (copying any data from old to new) and leave the VBA locked away.

BSB

interesting question, as I am looking for something similar.
I am looking for a way to update the workbook open event, and I also have my VBE protected.
Following this thread with great interest.

Here is a SendKeys one that will work with a little tinkering.

Cannot find where I originally pinched it from but it's been sat in the "This might come in useful" folder for several years now...

Please Login or Register  to view this content.

BSB

Thanks BadlySpelledBuoy

This will come in handy, if I get it to work.
I have not tryid it yet.

No problem. Good luck with it.

BSB