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.
Do you have Google Desktop or any other COM addins installed? They can also cause that problem.
Everyone who confuses correlation and causation ends up dead.
No, I don't have google desktop installed on my machine. Neither I am having any other addins.
Are you 100% sure about having no addins at all? That is the only other cause of that problem that I know of.
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?
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.
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
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.
It is not showing all the COM addins. Could you please help me in getting these addins removed via Code?
Try this:
Please Login or Register to view this content.
I Tried the method. It threw an error saying "HKEY_LOCAL_MACHINE can not be changed"
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.
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.
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.
I opened Excel in Safe mode. As it is not allowing macros to run, there was no prompt this time.
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.
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
That makes no sense at all to me.
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:
If anyone has a chance to try this, could you let me know if it helps for you and/or your clients.Please Login or Register to view this content.
Jon Peltier
http://PeltierTech.com/
OMG! THANK YOU! Been driving me crazy for WEEEEEEKS!
Actually... didn't work. ooops
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.
Problem is Dropbox. Disable Dropbox and no password prompt, enable again and password pops up.Originally Posted by anuj1781
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks