I have a big Excel-VBA project, when user tried to exit from the project they get password prompt. They have to keep clicking cancel on the password prompt to make it go. Unable to find any help for this. Please help!
So when they exit from the project, you must have a Workbook_beforeclose OR Beforesave event firing.
You may benefit from posting the exit code, and someone will assist with finding the problem.
My guess is it is being caused by an add-in. There are some instructions and some code on the 3rd link (ExcelForum) which should help you investigate it.
Sub DisconnectCOM()
Dim objCOMAdddin as COMAddin
For Each objCOMAddin In Application.COMAddIns
objCOMAddin.Connect = False
Next objCOMAddinEnd Sub
</PRE>
got this code from third link to remove com object hope this works, i will try to put it on exit button sub and tell users to test this out.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.