+ Reply to Thread
Results 1 to 24 of 24

VBA password prompt after Excel closes

  1. #1
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Unhappy VBA password prompt after Excel closes

    Hi All,

    I am new to this forum.
    I am facing an issue with my VBA programming. I have protected my VBA code. But whenever I closes excel after closing down everything, it prompts for VBA password.

    I have looked at this link:-
    http://support.microsoft.com/kb/280454

    But the problem is I dont have VB installed on my machine.
    Is there any way to work around this?

    Appreciate your help in advance.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    Do you have Google Desktop or any other COM addins installed? They can also cause that problem.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    No, I don't have google desktop installed on my machine. Neither I am having any other addins.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    Are you 100% sure about having no addins at all? That is the only other cause of that problem that I know of.

  5. #5
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    I checked in Add in Manager in VBA, There is no add-in there. Is there a way to find out addin installed other than checking in VBA editor?

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    You need to be looking in the main Excel window, not in the VBEditor. Try running this macro:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    Hey, Thanks for this code. I ran the code. It seems like there are two COM addins Microstrategy and Snagit which are connected right now. I am not sure how shall I remove these

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    To add the 'COM add-ins' dialog to the toolbar in Excel 2003 and earlier:

    1. From the menu, select View-Toolbars-Customize...
    2. Select the Commands tab.
    3. Select 'Tools' in the left hand list
    4. Scroll about halfway down the right hand list and drag the 'COM Addins' item onto a toolbar.
    5. Close the customize dialog.
    6. Click the COM addins button that you added to the toolbar.

    NOte: any COM addins that have been installed for all users will not appear in this list, and can only be disabled via code or the registry.

  9. #9
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    It is not showing all the COM addins. Could you please help me in getting these addins removed via Code?

  10. #10
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    Try this:
    Please Login or Register  to view this content.

  11. #11
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    I Tried the method. It threw an error saying "HKEY_LOCAL_MACHINE can not be changed"

  12. #12
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    Then you will need to talk to your IT people, I think. It sounds as though you don't have the rights to remove the addins.

  13. #13
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    In This article :- http://support.microsoft.com/kb/280454
    They have mentioned a workaround. But as I don't have VB I can not create a Exceltest ActiveX Dll. Would this work? Can anyonle create that activeX dll and send it across? It would be a big Help.

  14. #14
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    That won't help you anyway.
    Try starting excel in safe mode (hold down Ctrl key while opening it) and then open and close your workbook. If you don't get the prompt, then you need your it people to remove the addins.

  15. #15
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    I opened Excel in Safe mode. As it is not allowing macros to run, there was no prompt this time.

  16. #16
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    You can enable and run macros in Safe Mode. If you are not getting the prompt, I suspect it is because the addins are not loaded, so you need to get your IT department to sort them out.

  17. #17
    Registered User
    Join Date
    10-19-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: VBA password prompt after Excel closes

    Hey I got a solution for this.
    Try to see if you have any queried data table in your excel sheet. If your data is coming from Database then you do not require data being saved in the sheet.
    Delete any Data table saved in the workbook, save it and close.
    Don't keep automatic save option in the VBA Code. Better if you keep thisworkbook.close False.
    Regards,
    Anuj

  18. #18
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: VBA password prompt after Excel closes

    That makes no sense at all to me.

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

    Re: VBA password prompt after Excel closes

    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/

  20. #20
    Registered User
    Join Date
    10-04-2012
    Location
    Warrenton, VA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    5

    Re: VBA password prompt after Excel closes

    OMG! THANK YOU! Been driving me crazy for WEEEEEEKS!

  21. #21
    Registered User
    Join Date
    10-04-2012
    Location
    Warrenton, VA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    5

    Re: VBA password prompt after Excel closes

    Actually... didn't work. ooops

  22. #22
    Registered User
    Join Date
    09-22-2016
    Location
    Berlin
    MS-Off Ver
    10
    Posts
    1

    Re: VBA password prompt after Excel closes

    I had the same problem and resolved it by deactivating every active COM addin one after another until I found the bad guy.
    In my case "Microsoft Excel Code Compatibility Inspector" COM-Add in was the cause. This addon came along with installation of MS Visual Studio.

    Hope that helps anyone.

  23. #23
    Registered User
    Join Date
    03-21-2012
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    1
    Quote Originally Posted by anuj1781 View Post
    Hi All,

    I am new to this forum.
    I am facing an issue with my VBA programming. I have protected my VBA code. But whenever I closes excel after closing down everything, it prompts for VBA password.

    I have looked at this link:-
    http://support.microsoft.com/kb/280454

    But the problem is I dont have VB installed on my machine.
    Is there any way to work around this?

    Problem not mutch talked about is Dropbox. Disable Dropbox and no pass prompt.

    Appreciate your help in advance.
    Problem is Dropbox. Disable Dropbox and no password prompt, enable again and password pops up.

  24. #24
    Registered User
    Join Date
    10-04-2012
    Location
    Warrenton, VA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    5

    Re: VBA password prompt after Excel closes

    Hey man, thanks for the reply. I will try this. I do have DropBox. I will say though that after exhaustive research I have discovered this problem can be caused by any number of resident programs. It's very hard to track down.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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