Unlocking vba project using application.username

Hello all,

I am curious if there is a method to unlock a vba project using application.username?

currently I have all of my projects password protected but would like to give one other person access without him having to remember or keep track of the password.

I use if application.username = "username" a lot of unprotect sheets and to show very hidden sheets at workbook open and am hoping i can do the same to unloack a project.

Please let me know if there is method to unlock a vba project from within vba at workbook open.

Thank you,

Also note the method needs to work for 64bit application.

Unfortunately, VBA does not expose the VBProject password via object model.

So there is no direct way of achieving what you are looking for.

One workaround is to use SendKeys to simulate keystrokes. But this method is not particularly reliable.

Found one such example below.
https://www.pcreview.co.uk/threads/s...g-vba.2071944/

Darn, I really do not want to use sendkeys on something like this.

If anything went wrong I could be locked out of the project myself and there is hours of coding in some of them.

I tried something like this http://www.siddharthrout.com/2013/04...that-you-know/ that i had found but i get a compile error on the declare statements. It says "The code in this project must be updated for use on 64-bit systems."

Ive never seen this before have you?

You'd need to declare function as PtrSafe. It's mandatory for 64 bit systems.

You can find detail in link below.
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

Ah gotcha.

I think i can figure it out.

We will see.