Prompted for the VBA project password on Workbook close

[zplugger]

Been using this invoice for years, now have this problem once in a while.Does not always request password on close, seems like it only happens when I'm online and the file does a syn with dropbox.Do not have google search on computer,only common add-in is adobe acobat, it has all updates. Anybody had this problem,and where do I start to debug?.When it promptes for password and I type it in it says invalid,not sure what going on.Running Office 2013.

Thanks Z

[gmr4evr1]

May not be the issue but I have seen this problem not too long ago. Check to be sure that the password line has

Please Login or Register  to view this content.

Not

Please Login or Register  to view this content.

Note the missing : in the second example.

[zplugger]

I will have a look gmr4evr1, not sure the vbaproject password is in any of code.I set it in the properties of the VBAProject-Project Properties Protection window. Part of the invoice can create a pdf with active x button,using Acrobat Pdfmaker Office Com Addin, wonder if this can cause problem.

[gmr4evr1]

Hmmm......ActiveX buttons are not very "stable" or "realiable" I guess is the best way to describe it. The issue might be with the ActiveX. You will find that most people here do not recommend using ActiveX buttons/controls

[zplugger]

Thanks, driving me nuts on this problem. Ran Perfect for years,just started having issue.

[gmr4evr1]

Did you switch from an earlier version of excel/office to 2013? Cause that in itself can reek havoc on things in excel

[zplugger]

Running this workbook on 3 machines that syn with dropbox, two machines have office 2013 and the other is 2010. Could this be a issue? Does not happen all the time,can't put my finger on what is doing this.When the password comes up and I type in the password it says invalid,I know it the right password for the project. Not sure what it wants,like a ghost book is open.Only add-in is a popup calendar and it has no vba lock.Would it help to set all machines to 2013? Is there a code to add in workbook close to close all userforms if one was open? Thanks for any suggestions on this.

[gmr4evr1]

Maybe it has something to do with dropbox? There are user forms in the workbook? If so, there's got to be code somewhere. To answer your question, if they are excel UserForms, there is a way to close other UserForms when another is open

[zplugger]

After many hours of testing problem,my solution was turn off dropbox when working with workbook.I can have dropbox off and workbook runs perfect,turn dropbox on and nothing but problems.I tried Pause Syncing in dropbox with no luck, it has to be shutdown and not running.All my files are in the dropbox folder, so I sync after finish closing workbook.Not sure what is causing this but will sync folder after workbook is closed. Maybe this can help someone else if they are running into problems using dropbox.

[gmr4evr1]

Glad you were able to narrow down the issue. Yes, hopefully it will help others out as well.

[zplugger]

Need to find a way to close dropbox with a vbscript Script file ? , maybe after workbook closes call another vbscript to run dropbox. I seen script file to close outlook but not dropbox.

[indrapurkay]

I have been running the same macro for a year, and all of a sudden I started getting the VBA password upon closing the spreadsheet. Unlike zplugger's case, I am opening a file on my desktop and encountered this problem. After struggling for a day with Add-Ins, reinstalling Excel 2010 and sundry other suggestions, I tried zplugger's suggestion. I closed dropbox before running my macro. The problem goes away. Closes nicely. Enable DropBox - the problem comes back. I am running Excel 2010. There is no obvious linkage with DropBox in my excel program, but empirically, I have established the root cause to be DropBox being active in the PC,for this problem to occur. Perhaps some SME would suggest what we can do to avoid this problem with Excel and DropBox both active at the same time.
Incidentally, when one does get the VBA project password prompt, keeping the Escape key pressed will finally close the password prompt window.

[zplugger]

Made a contact with dropbox on problem, will post any answers I get.I guess for now I will remove the VBA password from workbook,hope nobody changes the code work. I set up dropbox on another computer and password another workbook and get no promps for vbaproject password? Just not sure it happens on one computer and not another, hope dropbox can answer this.