PDA

View Full Version : Code to unprotect wbaproject



Jeevie
07-30-2013, 04:18 AM
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
07-30-2013, 04:56 AM
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
07-30-2013, 07:01 AM
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
07-30-2013, 08:35 AM
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
07-30-2013, 09:43 AM
http://www.vbaexpress.com/forum/showthread.php?t=43809