cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Wanna become a Super User? Learn more about it here

Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

481 Views
25 Comments
15 Kudos
Highlighted
Level 1
‎09-27-2015 03:05 AM

Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Excel files stored in dropbox that have a password protected VBA project, show a userform in the course of their use, and are closed before saving changes (choosing to save changes when prompted), cause a prompt for the excel VBAProject Password after excel closes. 

This only occurs when Dropbox Badge is enabled and never occurred prior to Badge's implementation. 

This problem is similar to that described in the Microsoft knowledge base (https://support.microsoft.com/en-us/kb/280454) but doesn't involve a COM add-in (removing COM addins or setting their connections to false has no effect).

It has exactly the same symptoms as the problem with the Acrobat PDFMaker Excel add-in several years ago (https://forums.adobe.com/message/5916268).

It would appear that Badge is interfering with proper closing of Excel and releasing of file references.

Here is a link to a simple file that replicates the problem when it is stored in a Dropbox folder on PC and Badge is active: https://www.dropbox.com/s/36s8ct1n2i5r5yg/Simple%20Password%20Prompt%20Generator.xlsm?dl=0

Thanks!

25 Replies
Level 1
‎09-28-2015 08:48 PM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

I can confirm this occurrence, additionally; it does not just affect documents stored in drop box, but any OPENED document with a password protected VBA project that utilizes UserForms.

If the document is opened, the userform is opened, then the document is closed and the application is closed (Excel) the password will appear regardless if its stored within Drop Box.

 

Dropboxer
‎09-30-2015 10:36 AM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Hi Moss and Nate,

Thanks a million for reporting this! I just wanted to let you know that our product specialist is currently looking into this issue.

We'll update you as soon as we have narrowed down the problem. Please hang in there for us for now!

Dropboxer
‎10-02-2015 07:40 AM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Hi there!

Just a quick update. We have been able to reproduce this behaviour and have alerted our engineering team. They are working on identifying a fix. Unfortunately, there is no timeline for it yet. We'll definitely keep you posted!

Thanks for your patience!

Level 1
‎10-02-2015 01:35 PM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Sofia thank you for the Update! I am looking forward to the resolution to this issue and appreciate all of your return feedback to let me know where it stands.

Cheers!

Level 1
‎10-02-2015 10:47 PM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

I'll second that! I'm glad to know that you're working on it, and I appreciate your quick response to begin addressing the issue. The Badge added a feature I had really been hoping for (knowing when someone else is working on a file), so I was disappointed when I found it was also causing this error. Hopefully the issue can be resolved I and my clients can begin taking full advantage of the Badge's capabilities.

Dropboxer
‎10-05-2015 02:59 PM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Absolutely understand where you are coming from! We'll definitely keep you in the loop here. 

Level 1
‎10-16-2015 11:17 PM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Any progress made on this?  Excel sometimes crashes as a result of this, causing me to lose work.

Level 1
‎10-26-2015 12:18 PM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Any progress? 

Dropboxer
‎10-29-2015 11:42 AM

Re: Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

Hi all,

Unfortunately we don't have a resolution yet. Our engineering team is still working on a fix.

Thanks again for your patience.