"VBA Excel Password Prompt After Close" – Know How to Resolve the Issue

VBA Project Password Dialogue Box Shown after Closing Excel

"I have created many applications from last 20 years in different platforms (ASP, SQL, VBA, VB, etc). Recently I had a bug report that comes up from an add-in called Acrobat PDFMaker Office COM Addin developed by Adobe Acrobat. So, Kindly suggest me a suitable solution that will help to resolve my problem."

Are you also getting any VBA Excel password prompt after close, while using XLA/XLS sheet. An application that generates the problem is built in function in MS Excel. It has the Userform, which contains a list box in it. The position of a list box will be different depending on a large number of parameters and it is programmatically changed. Although, whenever the Userform has been displayed and users may close that file then, VBA Project Password prompt pop up. The password pop-up has been canceled 2-5 times before it all just disappears. Therefore, in the upcoming section, we are going to discuss a manual solution that will help to recover VBA Project password in the simplest and easiest ways. Before that, let us describe few conditions that affect certain XLSM files.

Some Trigger Conditions Why VBA Excel Password Prompt After Close

With a known bad workbook, I do not have any problem to trigger all these conditions:

• The procedure does not involve the use of a UserForm (Displays the UserForm which can be appeared as the trigger conditions).
• XLSM contains all UserForms that can be removed.
• XLSM has a password for VBA Project in MS Excel and it can be deleted easily (These the Password Prompts will not appear if the project was not locked to view).
• Enter the password of VBA Project that was entered before closing the XLSM file.
• The.xlsm is converted into.xlam file.

Manual Tricks to Remove the Password from a VBA Project

If anyone who wants to help identify the main cause of "Excel password prompt after close" problem, here is just a simple test for creating the XLSM file. Let's have a look:

1. First of all, you have to create a new XLSM file.
2. Then, add 1x module and 1x UserForm under the VBA editor in Excel.
3. After that, add two command buttons into the UserForm.
4. Now, copy that code at the bottom of this post inside the UserForm module.
5. Again, copy the code at bottom of this post within the standard Module.
6. Next, Add the button to the particular Sheet and then, assign only the visible macros into it.
7. Open VBA Project options>> Lock this project to view and add the exact password.
8. In the end, Save and Close the.xlsm file.

To check the workbook, open it. Afterwards, run the macro and Close MS Excel.

Make sure that the glitch does not trigger again and again and VBA Excel password prompt after close. So you must open/run/close multiple times inside a row to view if ever it happens or not.

Professional Way to Recover VBA Project Password of XLA/XLS Files

If above-stated solution may get fail, users can take help of a reliable third party tool named as VBA Password Recovery. It is designed in such a way to remove the lost password of VBA files without any hassle. This application is one of the best solutions that will help to unlock VBA project password of any length in an efficient manner. Moreover, it has some additional features that will help to remove the password from the file.

Wrapping Up

How to fix ‘VBA Project password dialogue box shown after closing Excel" is one of the major issues. After considering the above scenario, we have discussed a direct manual solution to resolve such type of issue. Besides this, we have suggested a reliable solution i.e., VBA Password Recovery that will help to recover lost VBA project password. It is one of the perfect solutions through which users can easily access password protected VBA files in a quick and efficient way and troubleshoot the issue of VBA Excel password prompt after close.

A Tech Geek, blogger, who wants to explore more and share information related to various applications like Outlook, Office 365, etc. and its errors.