Hi All

I have not gotten to run/study Aflatoon's (at #14) or Kenneth's (at #16) code yet, but hope to get a chance to through the course of the evening. Meanwhile, I am afraid I must be particularly thick-headed today, and not 'getting' a couple of things.

Quote Originally Posted by theta
When you unlock a project, Excel presents a prompt to the user stating the project was unlocked. You have to manualy close / ESC this window. I was hoping the code would capture this window and action the close handle?
I do not get a prompt in either 2000 or 2010. Manually, if I double-click or click the plus sign in the Project window, the Password dialog comes up, and upon entering the password and clicking the <OK> button, the project "expands" in the project window. Likewise, if I select the project in the project window, and then go to Tools|Properties from VBE's menubar, I am first prompted for the password, and the then Properties dialog pops up. Is there another dialog that advises that the project was unlocked? If so, should I be looking in options, or is it specific to a version or??? Sorry if I am missing something I should already be seeing.

Quote Originally Posted by Kenneth Hobs
Aflatoon's last code will dismiss the unlocked dialog.

I added some missing API's and some constants. I also have a few extra API's but that does not really hurt anything unless you have a lots of other stuff going on that might exceed a stack limit. I tested it in xppro. It should be tested with UAC turned on. I suspect that it will still work ok since it does not use SendKeys()...
Hi Kenneth,

Hope all is well in your neck of the woods

For whatever reason, I am not catching what UAC is

Thank you both so much,

Mark