Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

[Wyn H.]

This is an issue for us and our clients.

It needs resolving,  our recommendation is now to use OneDrive

[S S.10]

@Nico B. Are you able to provide more details as this does not address the issue for me?

I have recorded a quick (<1 min) video illustrating what I tried, using your code above and how it does not work for me.  Can you see what I might be missing?

http://screencast.com/t/flK1j0A8d5Rv

Replication steps:

1. Launch Excel (2010)
2. Open VBA editor (used the shortcut keys <Alt><F11>)
3. Insert UserForm
4. Rename UserForm1 to frmTest
5. Insert Module
6. Copy and paste and format your code above into Module1
7. Add event handler Private Sub Workbook_Open() to ThisWorkbook and have it call OpenUserform
8. Compile to ensure there are no errors (Debug | Compile VBAProject)
9. Open VBAProject Properties
10. Go to the Protection tab
11. Check Lock project for viewing
12. Enter and confirm password
13. Save As type Excel Macro-Enabled Workbook, with File name: Book1.xlsxm
14. Close the VBA Editor
15. Save the spreadsheet
16. Close the spreadsheet
17. Open the spreadsheet
18. Click on Enable Content
19. Close the UserForm1
20. Close the spreadsheet

Expected result:

Excel should close with no prompts or errors

Actual result:

I am prompted for the VBAProject Password.  When I click on Cancel, Excel crashes

[S S.10]

Thank you for sharing your file.  I downloaded it and it has the same issue for me in that it displays the password prompt upon close.

Here is a quick video demonstrating how when Dropbox Badge setting is set to "Always show", the password prompt still comes up.  If the Dropbox Badge setting is set to "Never show", the password prompt does not come up.

http://screencast.com/t/C1GZ7eYBH

Were you able to confirm that your file works for your customer when they have the Dropbox Badge setting set to "Always show"?

[Nico B.2]

I'm sorry I gave you false hope. It looked like I found the solution but it turned out the problem returned. I'm afraid something went wrong during our first test.

I've deleted my comments.

[McCrizzle]

I confirm this is a problem that needs a resolution.  I just came across the problem, but see others have had the same issue since 2015.  It's now 2017 and still not resolved?!?!  Dropbox, any update on fixing this bug? 

[paulbrit]

Hi Dropbox. Is this bug still being worked on? While turning off the badge does work as a short-term solution, it is irritating for clients who use the badge functionality! Please provide an update on progress with a fix for the issue.

[Jaccobk]

I'm having this same issue its been since 2015 this issue was noticed. Come on. I just wasted 4 hours deleting Sub by sub trying to figure out what I did wrong.... the only way I knew to search for this was when I restarted and tried running my excel macros before drop box got booted up.

[This thread is now closed by moderators due to inactivity. If you're experiencing a similar behavior, feel free to start a new discussion in the Dropbox Community here.]