Mark,
I’ve just seen 3 new posts with similar complaints in another Excel group.
No answers available – but I’m betting Microsoft has “done” something again…
‘—————————————————-
1. “My project is password protected. If I open it, cause a form to be
displayed (any form) and then close or quit Excel, the project
password prompt appears.”
2. “Users running our Excel spreadsheet tool were having no problems until
recently. We’ve had several users get the Password Prompt for VBA
Project Appears After Excel Quits when they close our application. We
have over 8000 users worldwide and lately we’ve had about 5 users get
the vba password prompt when they exit the tool. Any ideas why this
would be happening?”
3. “That’s very odd, this started happening to us recently too. IT rolled out a
“hotfix” which incorporated a new Excel EXE (from Microsoft) – my suspicions
lie in this direction.”
‘—————————————————-
Regards,
Jim Cone
San Francisco, CA
My company just upgraded us all to Office 2003 and I had an email from a co-worker in England that whenever he exits the .xls file I sent him (which has lots of VBA code) that he gets prompted for the project password. I wasn’t able to duplicate it but now know he’s not nuts. I have Office 2003 on my work laptop and wondered why I don’t see the error. My only guess so far is that I have a digital certificate installed which I use to sign my Excel projects. Maybe that prevents the password dialog from appearing? I do not have the Google desktop search utility installed as another poster mentioned.
