Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project password on close
Hi, I have a fairly extensive VBA project in Excel, which I've locked bot for viewing and for property changes with a password. Every now an then (but not always), the project password dialog will appear when close the workbook, and I either have to enter in the vba projec password or press cancel 20 or 30 times--something that would be ver annoying for my users. Can anyone tell me what is causing this and ho I may get around it? thanks -- mmm999 ----------------------------------------------------------------------- mmm9999's Profile: http://www.excelforum.com/member.php...fo&userid=2646 View this thread: http://www.excelforum.com/showthread.php?threadid=39793 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project password on close
Do you have the google desktop search program installed?
Lots of people complained that it would cause this kind of problem. You may want to read this thread: http://google.co.uk/groups?selm=422E...M.com& rnum=1 ps. Google has released version 2.0 (still beta). I'm not sure if it fixed the problem, though. mmm9999 wrote: Hi, I have a fairly extensive VBA project in Excel, which I've locked both for viewing and for property changes with a password. Every now and then (but not always), the project password dialog will appear when I close the workbook, and I either have to enter in the vba project password or press cancel 20 or 30 times--something that would be very annoying for my users. Can anyone tell me what is causing this and how I may get around it? thanks. -- mmm9999 ------------------------------------------------------------------------ mmm9999's Profile: http://www.excelforum.com/member.php...o&userid=26464 View this thread: http://www.excelforum.com/showthread...hreadid=397939 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project password on close
I don't have Google desktop installed, but I do have the toolbar. ( had read the same thing earlier and decided to leave it, but some of m beta users who don't have Google desktop were having the problem.) thanks -- mmm999 ----------------------------------------------------------------------- mmm9999's Profile: http://www.excelforum.com/member.php...fo&userid=2646 View this thread: http://www.excelforum.com/showthread.php?threadid=39793 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project password on close
Do you have any other addins loaded that could cause the trouble?
How about the antivirus software--could you disable that (temporarily) and see what happens? mmm9999 wrote: I don't have Google desktop installed, but I do have the toolbar. (I had read the same thing earlier and decided to leave it, but some of my beta users who don't have Google desktop were having the problem.) thanks. -- mmm9999 ------------------------------------------------------------------------ mmm9999's Profile: http://www.excelforum.com/member.php...o&userid=26464 View this thread: http://www.excelforum.com/showthread...hreadid=397939 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA project password on close
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. -- mmm9999 ------------------------------------------------------------------------ mmm9999's Profile: http://www.excelforum.com/member.php...o&userid=26464 View this thread: http://www.excelforum.com/showthread...hreadid=397939 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA project does not close when workbook is closed | Excel Programming | |||
VBA project does not close when workbook is closed | Excel Programming | |||
VBA Project - Open/Close with Macro | Excel Worksheet Functions | |||
VBA project does not close when workbook is closed | Excel Programming | |||
Accesing vba project from wb that has vba project password protected | Excel Programming |