Asks for password for protected VBA code when closing Excel

Hi, there
I have a spreadsheet with a piece of VBA code built in at "ThisWorkbook" as below:

Please Login or Register  to view this content.

Additionally, there are some forms with built in VBA codes. All the VBA codes are protected with the same password. Here is the problem, after close this speadsheet, if it is attempted to close Excel after it, a message comes out and asks for password for the VBA code. A several methods were tried to get rid of this problem. It seems it only works if do the following step

Close the spreadsheet
Open Microsoft Visual basic editor
Highlight the VBA project of the speadsheet
Close Microsoft Visual basic editor
Close Excel.

Does anybody have even met this problem before? How can I solve it without going through the step listed above?

Thanks in advance. Your time and effort will be highly appreciate.

Best regards,
Chunli

Do you have any COM addins such as Google Desktop installed? That has been known to cause that problem.

Not without either uninstalling them or editing the registry to alter their loadbehavior property generally.
If you fire up the COM add-ins dialog, what do you have there?

That's the Addins dialog, not the COM addins dialog. Run this code:

Please Login or Register  to view this content.

and tell me what's listed in the dialog.

Oops - should have figured that only works when you already have the button on a toolbar somewhere. Choose View-Toolbars-Customize..., then select the Commands tab, choose Tools from the left list, then about half way down the right list, select the 'COM add-ins...' button and drag it onto a toolbar. Now close the dialog and click the button you added to the menu.

You couldn't just have said there was nothing in the list?
It would seem that if you do have any COM addins they are installed for all users (those don't appear in that dialog) in which case there is probably nothing you can do about it. I suggest you talk to your IT department.

Have a look at this DDoE posting. Essentially, you need to alter the LoadBehavior of each COM addin to 2.

Thanks. It's working when I change the following HKEY to 2 ( Default 3).

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehavior

Considering using 2 might change the behavior of the addins, I followed the suggestion from Andrew and tried the code below:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Not (Application.VBE.MainWindow.Visible) Then
Application.VBE.MainWindow.Visible = True
Application.VBE.MainWindow.Visible = False
End If
End Sub

But Excel gives me an error message of 1004 and "Programmatic access to Visual Basic Project is not trusted".

Any suggestions?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Try removing google desktop to see if that helps, or if there's another addin causing the problem.