27 June 2017

How to Recover an Excel VBA Password

Stuck with a VBA document that’s password protected? Here’s how to pick the lock. It’s not unusual to take ownership of someone else’s Excel document, especially in the workplace. Usually, the transition goes smoothly — but there are pitfalls that can cause some real headaches. For instance, six months down the line you might try edit one of the VBA macros that’s integral to the spreadsheet, only to find that it’s password protected. What happens now? Well, with a bit of tinkering behind the scenes, it’s not too difficult to remove that protection entirely. Here’s how to eliminate password protection from...

Read the full article: How to Recover an Excel VBA Password

No comments:

Post a Comment