VBA Project Password Window Opens After Closing the Excel Workbook: Resolved

VBA Project Password Window Opens After Closing the Excel Workbook

Does your Excel asks for VBA Password on close? Are you also getting Excel VBA prompt for password? There are passwords entered to protect and encrypt an Excel workbook and code. But sometimes these can create problems for an individual user and show error messages. There is a common issue where the VBA Project password window opens after closing the Excel workbook. It needs to be canceled twice before it goes away. This can be a real hassle for any coder or developer. Many professionals have discussed this in multiple forums and blogs. This post has been written to resolve their problem to recover VBA Project password in the most simple and easy way. To know more read the following segment.

"I have a recurring issue with a user-form that I created with protected code in VBA Project. If changes are made anywhere to the program and closed manually a dialogue box appears. It asks for a VBA Project Password. It happens every time I choose File >> Exit but not when the red X is clicked. I have no way of solving this issue and believe me I have tried everything. Could anybody please help me why I am getting Excel VBA inputbox for password and how to resolve this issue?"

Possible Ways to Repair VBA Project Microsoft Excel Worksheet

Listed here are some of the ways to fix this issue when MS Excel asks for VBA password on close, and resume smooth working on VBA project code:

Solution#1: Close Excel Add-ins

These are added facility provided by a large enterprise for easier document management or printing. These can be downloaded and installed easily to an Office suite application. Some of them might not be properly designed cause abnormal behavior in VBA Project. It can be helpful to close down any or all add-ins to remove VBA password prompt when closing Excel. Especially the ones on the list below:

• Adobe Acrobat
• Dropbox
• Acrobat PDFMaker and many more.

Also, make sure that the latest Office suite and Windows updates have been applied. Try to close any third-party tools installed on the machine and check if the problem still persists. Change the registry to set the offending COM Add-in value from 3 to 2 and change it back if that does not help. Update Acrobat to VBA disable password prompt:

Solution#2: Design Class in ActiveX DLL to Properly Terminate Code

This situation can occur if modules are not properly handled by the Excel workbook. It can be a result of circular reference where a child’s reference to parent’s object is not released. It can be resolved by calling a method for one of the objects so that it could terminate properly. Following is a workaround for VBA Project password window opens after closing the Excel workbook. It replaces the standard Excel approach for closing by manually shutting down each object.

Solution#3: Manually Close Add-ins with Code

If the above method does not solve the issue of Excel VBA prompt for password, one can try to close COM AddIns references manually. Following is a code for the sub to remove VBA password prompt when closing Excel:

Solution#4 Save Workbook Before Closing

If the above code does not solve the problem that Microsoft Excel asks for VBA password on close, then the code can be altered accordingly. There is a way of calling "ThisWorkbook.Saved = True" before Workbook_BeforeClose event. It can be used in the following manner to VBA disable password prompt:

There are some users who find the manual solutions as a time-consuming procedure. Also, there are some who want to do crack VBA Project password in a quick as well as in a hassle-free way. So for these kinds of users, automated solutions are the best way to resolve this issue that VBA Project password Window opens after closing the Excel workbook. One such third-party tool is described in the next section.

An Optimum Solution to Recover VBA Excel Sheet Password

The manual method discussed here may not be enough to solve the problem at hand. One may require a specialized, automated solution designed just for such issues. It is to use a third-party software like the VBA Password Remover. It is built to recover any of the MS Office files from encryption. It comes with the ability to unlock multilingual password of any length. It can also create new ones if necessary. It works in Excel workbook, Access database, and Word documents. The tool works on all Windows 10 and earlier versions for both 32 and 64-bit machines.

Conclusion

This is a problem that has intermittently plagued many customers over the years when closing Excel. Microsoft Excel asks for VBA password on close, despite canceling the dialogue box number of times. Even the single Microsoft’s knowledge base article does not help. It is poorly understood and not many working solutions are available online. There are manual ways to fix VBA Project password window opens after closing the Excel workbook issue. Some of them have been discussed in this post. If those do not help there is a more reliable, convenient and cost-effective solution, to resolve this issue when Excel VBA prompt for password, is given at the end of the blog.