VBA Password query after App has ended.

[Firery]

I have created an Excel spread sheet with numerous sheets and numerous VBA forms and code.
I keep the VBA Project locked from viewing with a password.
I have been making slight improvements as you do, and my program is working fine.

Recently, on the odd occasion, after I have closed my Excel application, and after a few seconds, the VBA Project password dialog box appears on the desktop. It won't go with 'Cancel', I have to remove it via the task manager, or enter my password and then it disappears.

Has anyone experienced this, or knows what is causing it?
(It is NOT a consistant event)
[Windows XP Pro Sp2, Office XP Pro]
Thanks for any information.

On another note,
I would really like to thank all you guru's out there who help dummies like me.
The funny thing is, the more code I read from this site, the more I realise how little I know.

 

[rmikesmith]

Firery,

See my response in thread707-1036824, which includes a link to further discussion of the problem. Sounds like your issue.

The funny thing is, the more code I read from this site, the more I realise how little I know.

Likewise!


Regards,
Mike

 

[Firery]

Thanks rmikesmith
Your thread mainly describe my problem being caused by having GOOGLE Search installed.
I don't have it installed, so it must be something else.
I have had a good look at my Before_Close but can't identify anything there.

So I'm still looking

 

[rmikesmith]

I've searched the Microsoft excel.programming newsgroup and there are a number of postings with your same problem, also without Google Desktop Search installed. Unfortunately, no resolution. I suggest running your application on a different pc, if possible, to determine if the problem stems from a particular system configuration. The newsgroup replies also mention disabling any COM add-ins (Google Search being one) to see if that eliminates the problem.

Regards,
Mike

 

[Firery]

The problem has appeared on another PC running NT, without GOOGLE search.
The strange thing is that it is not consistant.