Author Topic: VBA Password Error When Closing the Spreadsheet  (Read 32706 times)

ssheldon

  • Newbie
  • *
  • Posts: 15
    • View Profile
« Last Edit: July 15, 2017, 12:08:37 pm by ssheldon »

ssheldon

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: VBA Password Error When Closing the Spreadsheet
« Reply #16 on: July 16, 2017, 08:41:04 am »
I saw this solution for one user. Maybe it will help. Post #3

https://www.mrexcel.com/forum/excel-questions/889849-prompt-visual-basic-applications-project-password-after-excel-closes-dropbox-badge.html

or this:

https://stackoverflow.com/questions/23571760/vba-password-prompt-when-closing-excel

I did test this and it has worked to get rid of the password box. In my dropbox settings preferences I switched the Badge setting from Always Show to Never Show. I haven't had the problem since.

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 431
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: VBA Password Error When Closing the Spreadsheet
« Reply #17 on: July 16, 2017, 05:26:47 pm »
You're awesome!  Thank you!  I will sticky this when I get to my computer posting from cell phone right now)