EXCEL: RunTime UnProtect VBA Project Password

[[email protected]]

Dear All

I' am using a Code which is not executed on a Protected VBA Project.

VBA Project Password is - "XYZ"

Hence, I' want a Code for UnProtecting VBA Project which I' can Run before my Code.

Thanks
MG

[JosephP]

the only options I have ever seen are http://www.vbaexpress.com/forum/showthread.php?t=43809

[[email protected]]

Thanks JosephP for reply

I' have seen your link, but there are many codes and I' am not sure which code to be use.

Could you please do a favor by putting the code here mentioning the way I' use it in my File

That will be really appr

[JosephP]

the code in post #16 in the link

[[email protected]]

Ok

Do I' need to put my given password in the code?

If yes? where..

and where should I' put this code in my file?

module or before my code.

[JosephP]

yes-in the routine at the bottom that unlocks the project (I think it says "myPassword")

put it in a separate module

[[email protected]]

Thanks it working

But !!!!

I' am getting error message - "Programmatic access to Visual Basic Project is not trusted"

If I' tick the same in Excel option, no error is displayed and working fine

But how can I' force user to activate the same, because there are chances that user will keep this disabled

Could you please give me any suggestion for the same?

Thanks
MG

[JosephP]

you will have to give them a message to enable that setting

[[email protected]]

Are you saying that I' suppose to provide a instruction document

OR

Should I' mention the message in the Code itself - if yes? How?

Sorry for asking dumb things

[JosephP]

whichever you prefer. you can use a msgbox statement in the code or create a userform or use a worksheet with instructions on

[[email protected]]

Hey Joseph

Everything is working fine But....., with this code VBE is getting opened.

what to do for that.... I' don't want the VBA Code remain open after running the Code

[JosephP]

do you mean you want the vbe closed? how do you know the user didn't already have it open?

[[email protected]]

Even they have open it, VBE should be closed after running our Code.

Anyways in my case no one will open VBE, as the users are not that much capable.

But they can take objection that after some xyz process VBE window is opened.

Please help me with it.

[JosephP]

Please Login or Register  to view this content.

oughta do it