LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 129
Default VBA project password on close

Hi,

if you use outlook express as a default mailer (Control panel
Internet Options Programs), try to set another mailer and open/close
the workbook. if the project does not remain in the visual basic
editor after closing, probably outlook express had held the workbook.

--
HTH,

okaizawa

mmm9999 wrote:
No I don't. I'm not using any add-ins, and I don't have any
non-essential VBA project references. I added a little code to
ThisWorkbook_BeforeClose to make sure that all the forms are unloaded
(though I was pretty sure I did that anyway before) and I haven't had
the problem since then, but then again it's only been a couple of
hours.

 
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
VBA project does not close when workbook is closed SimonN Excel Programming 5 July 1st 20 05:47 AM
VBA project does not close when workbook is closed Simon Norris Excel Programming 5 March 2nd 16 05:34 PM
VBA Project - Open/Close with Macro Danny Excel Worksheet Functions 2 September 7th 07 11:02 PM
VBA project does not close when workbook is closed SimonN Excel Programming 3 October 25th 04 09:23 PM
Accesing vba project from wb that has vba project password protected cassidyr1 Excel Programming 2 July 3rd 04 01:49 PM


All times are GMT +1. The time now is 01:13 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"