Unprotect VBA - Run Code - Protect again (password is known)

[Bishonen]

Hi,

how would i proceed about that? I know the password and am running office 2007. Thanks!

[Tejas.T]

Please Login or Register  to view this content.

[Bishonen]

Hi Tejas,

thanks for your reply. Perhaps i didn't make myself clear: I'd like to unprotect the vba project, not the worksheet/book.

Thanks!

[JosephP]

you need windows api functions to do that-I think I saw a thread on this at vba express recently

[Tejas.T]

Hi,

I am surprised that why do you need to unprotect VBA project code to run the macro? Code can run without that too.

And if you really need it, I don't think it is possible.

[Bishonen]

Well, I think it's quite easy to think of a need for that: Many employees have a complex file with a vba code "hidden" within. I'd like to change the code a bit(got that one figured out), without giving the password to everyone.

I found one solution, which unfortunately can't be used in my case since many users have their own personal modules, while other dont +solver etc.

Please Login or Register  to view this content.

I'll take a look for a API solution... thanks

ps: I can't just send a new file to all users since the file contains user input for multiple entries.

[JosephP]

found it: http://www.vbaexpress.com/forum/showthread.php?t=43809
based on some old code by the late Howard Kaikow

[JosephP]

this is why it is recommended to separate code from data-so you can just distribute a new code workbook or add-in ;-)

[Bishonen]

thanks a lot! Sometimes it's just impossible to separate the code from the file I'm afraid.

[JosephP]

I reckon that's pretty unlikely-difficult, sure, but not impossible and if you have a regular need to update the code you really ought to investigate the possibility ;-)