Users of some XLAutomation products have reported that a VBA password prompt is displayed when they exit Excel after using one of the XLAutomation products (eg Share Trade Tracker).
The password prompt is displayed and clicking cancel does not clear the prompt in some cases users must click cancel 20 times to finally exit Excel.
The issue has been reported by a small number of users and may be related to one or any of the following
password protection that is applied to the workbook
specific "Add-ins" that are not released once the workbook is closed
the method of closing Excel after using the workbook
A solution to this issue has been developed by the XLAutomation Support Team refer to the following VBA Password Prompt appears on Exit solution.
This article has been developed to replicate the issue using a Test workbook. Follow the steps below to replicate the issue and then test the solution.
If you are unable to replicate the issue then your computer does not have the configuration required to experience the issue.
Replicate VBA Password Prompt
- Download "TestVBAPasswordSolutionFinal.xlsm"
- Double Click on the workbook to open it - you may need to Enable Macros
- Select Option "Repeat Problem"
- Click on "Close" when the Form appears
- Close the workbook
You should then see the VBA Project Password prompt
Here is an image of the VBA Project Password prompt appearing on exit from the workbook.
VBA Password Prompt Solution
The XLAutomation Support team have developed the following solution to this problem. It involves a call to an external workbook to temporarily display a form prior to closing the original workbook.
This solution has worked in all cases for our customers and is used when required to resolve the issue for our products.
Download "TestVBAPasswordSolutionFinal.xlsm" and "FixVBAPasswordSolution.xlsm"
Save files into the same directory / folder
Select the Option "Call External Workbook"
Click on "Close" when the Form appears
Close the workbook
You should then see a Form pop-up temporarily from the External workbook
After that form disappears exit the workbook
The VBA Password Prompt should NOT appear
Here is an image of the VBA Project Password NOT appearing on exit from the workbook