cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Our new Dropbox updates make your online life easier. See how you can store online-only files, edit photos in Dropbox and annotate PDFs with these updates.

Apps and Installations

Have a question about a Dropbox app or installation? Reach out to the Dropbox Community and get solutions, help, and advice from members.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Dropbox Badge Causes Excel to Prompt for VBAProject Password After Closing

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

Wyn H.
New member | Level 1

This is an issue for us and our clients.

It needs resolving,  our recommendation is now to use OneDrive

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

Nico B.2
New member | Level 1
 

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

S S.10
New member | Level 1

@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

 

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

Nico B.2
New member | Level 1
 

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

S S.10
New member | Level 1

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"?

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

Nico B.2
New member | Level 1

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.

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

McCrizzle
New member | Level 2

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? 

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

paulbrit
Explorer | Level 4

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.

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

Jaccobk
New member | Level 2

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.]

Who's talking

Top contributors to this post

  • User avatar
    Jaccobk New member | Level 2
  • User avatar
    paulbrit Explorer | Level 4
  • User avatar
    McCrizzle New member | Level 2
  • User avatar
    Nico B.2 New member | Level 1
  • User avatar
    S S.10 New member | Level 1
What do Dropbox user levels mean?
Need more support?