jim wood wrote:The company I work employed some consulants a couple of years ago and they built some good stuff in excel. The consultancy no longer exists and we want to make changes to the underlying VBA. The problem we have is that the VBA is password protected and they never left us with the passwords. Does anybody know if there is a way round this?
No easy way around it I'm afraid, Jim. (As in, unlike breaking worksheet or workbook protection, a few lines of code won't do it.)
I suggest that you take a look at this page on JE McGimpsey's site:http://www.mcgimpsey.com/excel/fileandvbapwords.html
and this one on Chip Pearson's:http://cpearson.com/excel/password.htm
Now I've never used any of the products / services either; I downloaded a demo of one a few years back which promised to return the first two characters of the password, and it did, without fail. (Can't recall the name of it now.) So some of these apps will clearly work, though you have to pay a few bucks for them.