LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA Project Password prompt on Exit

I've read several posting about this problem, and all of them seem to have
been resolved by removing Google Desktop. The problem is that I do not have
Google Desktop.

Here is what I have found will make this problem occur. In my Excel file, I
have a VBA form, which is displayed, then remove from memory and set to
Nothing. After that, I create an ADO Connection Object that is opens a
connection to the current Excel file (trying to get around this same issue
when using MSQuery, but turns out it did not matter). The connnection is
then closed, the Object set to Nothing.

And that's all I have to do for the Project Password prompt to appear when
exiting Excel. I am using late binding, so there is no reference set to the
ADO library in my project.

Any ideas?

Thanks,

Malcolm
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
No prompt on exit in Excel 2003 nsm Setting up and Configuration of Excel 0 May 3rd 06 10:56 PM
save prompt for user exit, but no save prompt for batch import? lpj Excel Discussion (Misc queries) 1 February 25th 06 02:08 AM
Excel - Prompt to save on exit. Fenris Excel Discussion (Misc queries) 0 November 21st 05 05:11 PM
Password Prompt for VBA Project Appears After Excel Quits LAF[_6_] Excel Programming 8 April 23rd 05 11:26 PM
Excel 2003 when closing Excel after having opened a project locked for viewing.. password prompt??? braindead Excel Discussion (Misc queries) 0 March 25th 05 01:58 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"