Ever annoying VBA password prompt at close of excel.

As many users have listed on the Internet. I am also getting the pop-up asking for VBA password when closing excel.

I have my code deployed on approximately 50 laptops. Various manufacturers of laptops and versions of Windows ranging from Windows XP to Windows 10. All running Office 2010 or 2013. Only 4 machines have the popup error. I thought the problem was related to the last Microsoft update but does not appear to be the case. Has anyone come up with a solution or is it just trial an error? Seems to be related to forms. I can open a file have it load a file and then auto open a form, close it and save the file and the error will appear. Very repeatable on 4 machines but not on any other.

The following are a couple well written links relating to problem
http://www.excelforum.com/excel-prog...to-appear.html

http://www.mrexcel.com/forum/excel-q...ing-excel.html

Below is what I have for add-ins. They are all inactive or do they need to be totally removed from computer?
Add-Ins.jpg

Anyone with ideas?

I have attached sample file. Password for VBA is test
Very repeatable error on my computer. Open the file it auto opens a splash screen and then checks to see if pivot-table is loaded or not and then selects Order tab.
Then click X and then when requested save document.

Hello Epscan
Played around with you sample workbook and get the password prompt every time I have a com add-in on. I add this code in the workbook before close event and no longer get the prompt??

Please Login or Register  to view this content.

Just seems like every computer is different for the prompt and makes it hard to solve.The workbook I use get the prompt every time and when I enter the password it says invalid every time. Mabe this will solve your problem.
Z

Originally Posted by zplugger

Thinking the only known fix for this is (Take password off vbaproject).
Z

I have an alternative fix - however not all XLSMs can take advantage of it http://www.excelforum.com/excel-prog...ml#post4054436

Originally Posted by Epscan

I have been playing around using the Auto_close with your idea.

Interesting. How is it going? A few months ago I had been playing around with Workbook_BeforeClose event - I was working on the theory that the glitch is only triggered where Excel thinks that the file needed to be saved (which would explain why I never get the glitch after converting the XLSM to XLAM) I should resume my testing.

Originally Posted by Epscan

It seems like with code, it is closing faster than the application sees that it has been saved.

You have probably already thought of this - and I am clutching at straws here - but how about introducing a deliberate delay when closing? Either a Wait for 1 second and/or a DoEvents after saving the workbook?

Originally Posted by Epscan

I have just tried adding the following code and still pops up. Of course I don't always want to save but thought I would try it.

Please Login or Register  to view this content.

I am not familiar with DoEvents

Hmmm. Maybe ThisWorkbook.Save instead of ActiveWorkbook.Save?

Try adding "DoEvents" on the next line after saving the workbook. The DoEvents function surrenders execution of the macro so that the operating system can process other events. Like the operating system recognising the fact that the workbook has in fact been saved?!

Originally Posted by zplugger

Morning mc84excel
Glad to see someone else working on this,I try different things everyday with no luck.
Z

Here are two things that I have noticed:

1. I have never seen this error occur on XLAMs. It only occurs on XLSMs
2. I have never seen this error occur if the XLSM does not contain a UserForm

It's not just Dropbox - other COM add-ins have also caused this in the past, so it's worth checking what you have loaded.

If you open Excel in Safe Mode does the problem still occur? If not, then the problem is caused by one of the files (add-ins or workbooks) Excel is loading at startup.

Thanks for your reply rorya, Surprisingly when I opened it in safe mode and i did it 3-4 times it did not prompt me for password when I closed the workbook. I have checked there are no add-ins in it. OLE Automation is also disabled. Can you tell me a way to figure out what is causing the password prompt how to reach the exact point. Unfortunately, the code is property of a company and I cannot share it. It does not have any ADODB functions in it just normal excel functions and user forms in it. Any help will be appreciated! Another weird thing is that it doesn't asks for password all of the time it only asks it for sometimes. Which makes me think if there is some problem in code then why it does not always asks for password?

Did you try disabling the Power Map add-in?

Do your users actually have this problem?

Well if you can't disable whatever is causing it, you're out of luck.

Originally Posted by syedabdullah

I am not using any drop box but still getting this annoying password popup

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

It doesnt matter that is is related. You need to start your own thread, and post a link to this thread if you think it is related. We do not permit thread hijacking (posting your questions on another member's thread)