How to remove or unlock password of VBA macros from Excel

It is very quick and easy realize if a VBA project is locked. You can find out in two ways:

  1. In Excel, look for the "Developer" tab, click on the section " Macro ". You will have a window with different options on the screen. If the buttons below the «Run» button are grayed out, ie you click on them and cannot select them, it means that the cells are locked or protected with a password so that they cannot be changed.
  2. Click on the "Visual Basic" section you have within the same "Developer" you were in previously. You'll see that pretty much everything that appears in the editor window of Visual Basic is grayed out. Right in that window, the ¨ + ¨ symbol appears, next to the project you need to open or edit. When you press there, a small window will appear asking you for your password, clearly indicating that it is locked.

How to remove or unlock password of VBA macros from Excel




 

How to unlock VBA macro password in Excel

You need to follow the following steps:

  1. Locate the file you want in a folder to unlock. Click to change the name and delete the extension displayed by default. You should insert the word "zip" in place of the extension you currently have. For example, if your macro name is ¨Project01.xlsm¨, you will need to change the extension ¨xlsm¨ to ¨zip¨. It would look like this: ¨Proyecto01.zip¨. Press the "Enter" button on your keyboard.
  2. Click "Yes" when the "Rename" window opens. With this step you have just created a zip file.
  3. Go to the file you just created and right click, select the "Extract here" option.
  4. Open the "xl" folder. There you will find the "vbaproject" file, which you want to access.
  5. apri the HxD HEX Editor program, which you must have previously downloaded, and drag the file that is locked there. Various codes will open.
  6.  In the program menu, select "Search".
  7. Enter the letters "PB". Click on «OK». It will direct you to the section where exactly the code you need is located.
  8. Select the letter "B", which is at the end of the code and replace it with an "x".
  9. Save and close the program.
  10. Back to the home folder. Delete the zip file, select all the remaining files and, by clicking with the right mouse button, press the option «Add to archive».
  11. The «File name and parameters» window will open. Replace the extension you have with "zip". Click on the «OK» button.
  12. A zip file will be created again, you will need to change the extension with the original one, "xlsm". Press «Enter». Click the «Yes» button in the window that appears.
  13. Verify that your file is already unlocked.

How to remove or unlock password of VBA macros from Excel




If you get an error after everything you've just done, you should go to VBAProject's Tools / Properties. Unlock the "Lock project for viewing" checkbox and accept. If the error continues to appear, go back to «VBAProject Properties», activate the lock box and enter a new password. Check.


When you have finished the procedure to unlock the password of Excel VBA macros, you will have learned that this program is not only for inserting formulas in text boxes, but also offers us a wide range of options.

Procedure if it is not possible to replace the extension "xlsm" with "zip"

If it doesn't give you a chance to change the extension as presented in step 1, you can solve it in the following way: Follow the following path: View / Options / Change folder and search options. A window will open in which you need to go to the «View» tab. You have to uncheck the box which says "Hide extensions for known file types". With this procedure you shouldn't have any more problems.



You already have all the information you need to unlock or remove password VBA macros in Excel. Discover all the other solutions that miracomosehace.com ti proposes to make your life easier.


add a comment of How to remove or unlock password of VBA macros from Excel
Comment sent successfully! We will review it in the next few hours.