How to remove VBA Macro Password from Excel/Word/PowerPoint (Automatic Method)
Rajtilak Bhattacharjee
-
October 20, 2019
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!
Breaking News
Connect on Facebook
Categories
Add-in
Adsense
Alteryx
Android
Apple
Apps
Artificial Intelligence
Blogger
Blogging
Browser
Business Intelligence
Chrome
Coding
Computer Vision
Data Analytics
Data Science
Data Visualization
Deep Learning
Downloads
EDA
Excel
Extension
Firefox
Gaming
Gartner
GitHub
Gmail
Google
Google Domains
Google Sheet
GPT3
Guest Post
How To
Humor
IEEE
Instagram
Interview
iOS
iPhone
Job
Jupyter
Kotlin
Language
Machine Learning
Macro
Mathematics
Medium
Microsoft
Mobile
NLP
Office
Opera
Paid Post
Pandas
Pixel
PowerPoint
Programming
PUBG
Python
R
Reddit
Safari
SAP
Security
Service
Social Media
Tableau
Templates
Tool
Training
VBA
VGG16
Video
Visualization
WhatsApp
Windows
Windows Phone
Word
WordPress