Code to unprotect wbaproject

[Jeevie]

Hi All

Please help me with directions to unlock protected Vbaproject of an external excel file using VBA with or without using sendkeys. Appreciate any help.

Thanks

[Paul_Hossler]

As EVERYONE here will tell you, helping to bypass passwords is not inaccordance with forum guidelines, even if it's your own workbook

Paul

[Kenneth Hobs]

IF you know the password and you just want to automate that, we can help you. It is alot of coding for a simple thing though.

[Jeevie]

Thanks Paul and Kenneth, let me explain the scenerio. I have list of workbooks with macros. Each of the workbook has a different password which is stored in a separate workbook. Whenever any of the macros needs to be debugged, the workbook vbaproject password needs to be unlocked. Hence I need to unlock the vbaproject password from another routine. Can you please help.

[Kenneth Hobs]

http://www.vbaexpress.com/forum/showthread.php?t=43809