I'd like to open a password protected VBAProject via code, copy out specific modules, then close the project (add-in).
I have an add-in that I share with multiple functions that are used by users. I have the add-in VBAProject password protected. This is enough to keep the nosey out. I know it is NOT secure.
Now, I would like the user to copy modules (that I have specified) out of the add-in vbaproject to their workbook. I have the code to copy the module but I cannot do it if the add-in project is locked.
How do I open the add-in VBAProject, pass the password to it, then close it again after it the copy module function is complete?