How to remove VBA Macro Password from Excel/Word/PowerPoint (Automatic Method)

Remove Macro Password

In the previous post, we learned how to remove password from a VBA macro in Excel, PowerPoint, or Word (both 32- and 64-bit) the hard way. In this post we will talk about how to remove the password using another macro.

1. Open the file containing the protected code
2. Open the VBA Editor so that you can see the project on the left side of the editor. If it is a PowerPoint file and you are unable to view the code, see this post to know how to view the code
3. Open a new file of the same file type. For example, if the locked code is inside a PowerPoint add-in, open a new PowerPoint blank file
4. Go to the VBA code editor, there under the new file create two new modules
5. In module 1, paste the following piece of code

6. In module 2, paste the following piece of code

7. Once done, run the code in module 2

Given below is a video to describe the entire process visually:

If you think this post helps, then don't forget to share it on Facebook or your favorite Social Media website!