+ Reply to Thread
Results 1 to 4 of 4

Prompt for VBA Project password after Excel closes with Dropbox Badge

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    alabama, US
    MS-Off Ver
    Excel 2016
    Posts
    2

    Prompt for VBA Project password after Excel closes with Dropbox Badge

    Many of my excel projects are stored in a Dropbox folder through the Dropbox desktop app on PC, windows 7 and 8.1, Excel 2013, 2016. Dropbox recently updated to include Dropbox Badge when excel files from a Dropbox folder are open in excel. When Dropbox Badge was implemented I started getting a prompt for a VBA Project password after excel closes in some of my excel projects. This occurs in both versions of windows and both versions of Excel when all of the following conditions are met:

    1. The workbook has a password protected VBA project
    2. A userform is displayed sometime during the file's use.
    3. The user closes the file after a change has been made and chooses to save the changes (saving separately before closing causes no error).
    4. The file is stored in a Dropbox folder and Dropbox Badge is enabled.
    5. (In some cases, having a msgbox prompt in the Workbook_BeforeClose event seems to cement the problem. Otherwise, it occasionally doesn't occur when closing.)

    I've attached a simple file that consistently creates the error (its VBA Project password is "a"). It opens a userform in the Workbook_Open event. The Userform changes a cell value. The user clicks the command button to close the form. The user clicks to close excel. The Workbook_BeforeClose event shows a msgbox (though this can generally be removed and still produce the error). The user clicks OK in the msgbox. The user chooses to save changes to the file. Excel closes, and then the VBAProject Password prompt appears. Switching the Dropbox Badge setting from Always Show to Never Show alleviates the problem.

    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 add-ins or setting their connections to false has no effect).

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

    Is anyone else having the same problem? Is there anything I can do besides hope Dropbox implements a fix?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    349

    Re: Prompt for VBA Project password after Excel closes with Dropbox Badge

    Cross-post;http://www.mrexcel.com/forum/excel-q...box-badge.html
    Read this;http://www.excelguru.ca/content.php?184
    Please click the * Add Reputation if this helps
    If solved remember to mark Thread as solved

    "I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."

  3. #3
    Registered User
    Join Date
    01-27-2013
    Location
    alabama, US
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Prompt for VBA Project password after Excel closes with Dropbox Badge

    Sorry about that. My first time posting... I actually tried to be careful about the rules and guidelines but obviously didn't understand the cross-posting posting part. Thanks for pointing me to the info.

  4. #4
    Spammer
    Join Date
    01-26-2010
    Location
    Worcester MA
    MS-Off Ver
    Excel 2003
    Posts
    184

    Re: Prompt for VBA Project password after Excel closes with Dropbox Badge

    This is a problem that has intermittently plagued my own Excel VBA add-ins for a small number of customers. I've documented the problem in my online documentation: VB Password Dialog - Peltier Tech Charts for Excel - Documentation.

    While working on a specific situation for a client, I came up with a solution. I don't know if it only works for his situation (on just my machine) or if it is more widely applicable.

    Insert the line "ThisWorkbook.Saved = True" at the end of the Workbook_BeforeClose event:

    Please Login or Register  to view this content.
    If anyone has a chance to try this, could you let me know if it helps for you and/or your clients.
    Jon Peltier
    http://PeltierTech.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Closing workbook causes VBA Project Password Prompt to appear
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-12-2020, 03:39 PM
  2. VBA password prompt after Excel closes
    By anuj1781 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-08-2016, 06:02 PM
  3. User Form causing Prompt for VBA Project Password when closing Excel
    By avr5iron in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-16-2016, 07:16 PM
  4. VBA Project password prompt
    By satyakantiwal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2011, 05:52 PM
  5. Stop prompt for password when Excel closes
    By ZagrebMike in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-23-2005, 07:06 PM
  6. [SOLVED] VBA Project Password prompt on Exit
    By Malcolm Makin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2005, 06:06 PM
  7. Replies: 0
    Last Post: 03-25-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1