vba code to open and unprotect vba editor window (having the password)

[Susy]

Hi there,



is it possible to open and unlock (security) the vba editor from withing a form (click of a buttom). I just want to let some people to be able to access the overall code of the project without having to ALT+F11.

Do you know of any code?

Thanks in advance.

[Micron]

I don't think so. AFAIK, the vba object model does not expose the vbe for editing, which is probably a good thing. SendKeys might work, but it would be very unreliable. You'd have to embed the password in code, exposing it to anyone who might find the code unlocked by the last person who unlocked it. You cannot rely on db shutdown to run any code that would re-lock it on exit.
Why not just either
- provide the password to those whom you want to expose the code to so they can unlock it for viewing
- dump the code to a document that only they can see/open
- make the db an mde or accde?

There seems to be exposure to the vb project, but it's properties are read only - not the code itself.
https://msdn.microsoft.com/en-us/lib.../ff195749.aspx

[Susy]

Hi Micron,

thanks for your contribution. As requested, I think I will just give the password to certain people.

Thanks again.