About more than a year ago, I was part of a team tasked with a company initiative to create a better Component Test Plan (CTP) template worksheet with Excel and VBA. It’s being used by another team and they wish to do some improvements to the tool. Problem: the VBA project for the worksheet was password protected – and I don’t know the password anymore. It would be superhuman for me to remember it by memory by now. So I needed a tool to break the password protected VBA project open. And fast. Thankfully, Google is fast and (coupled with some luck) I found what I needed here: http://www.davidbugden.com/?p=10. Now I am not sure if this technique is legal in all circumstances. But in my case, I felt that it was mostly my code so I didn’t see any problem breaking the VBA project open. Try it out when you need it. Hopefully it will be a great help to you too.
0 comments:
Post a Comment