+ Reply to Thread
Results 1 to 26 of 26

VBA ProjectPassword

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    VBA ProjectPassword

    This is part of another thread I have,but this is a different problem.So here we go,when the sample workbook has vbaproject password and you click the commandbutton Outlook
    will open behind the workbook.If there is no vbaproject password then Outlook will open on top of workbook?. Any ideas on what or where I should go to fix problem.Looking for any suggestion on this,tried on different computer with Excel 2007 and same problem,I'm running office 2013 32 bit.
    Password 1234
    Thank You
    Attached Files Attached Files
    Last edited by zplugger; 08-25-2015 at 05:20 PM.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,530

    Re: VBA ProjectPassword

    It's working fine for me in either configuration.
    PC - Excel 2010 Win7 32bit.
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,773

    Re: VBA ProjectPassword

    Just tried it with Windows 7 64 bit, Excel 2007 32-bit. Works fine with, or without a password. In both cases, it loads the Outlook window in front of the Excel window.

    No help but maybe it narrows down the possibilities.


    Regards, TMS

  4. #4
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    Thanks to both of you guys for trying,not sure why I have problem after VBAProject password is set. I install office 2013 on my labtop today and the same things happens.This
    one is driving nuts,so lost on what to try now.Going to friends house and try on his computer now,if it works I well really be lost.LOL Will post on what happens.

  5. #5
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA ProjectPassword

    Good luck!
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,773

    Re: VBA ProjectPassword

    You're welcome. Thanks for the rep.


    I guess that it's starting to point to Office 2013, or maybe a configuration option. Unfortunately, I can't offer any further help.


    Regards, TMS

  7. #7
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,530

    Re: VBA ProjectPassword

    You're welcome. Thanks for the rep.
    Ditto that

    Good luck!
    and that.

  8. #8
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    Well just got back home,friends computer running office 2007.No mater what I did on his computer it open behind the workbook.???????? This even makes me more lost,is ther a way to set focus on the inbox to open? Why is excel so different on every computer.

    Z

  9. #9
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,530

    Re: VBA ProjectPassword

    Why is excel so different on every computer.
    It's not. It's just your computer.

    That's how I feel when no one else can replicate a problem I'm having.

  10. #10
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA ProjectPassword

    I think the OP has now tried it on 3 different computers with 2 versions of excel and is getting the same result on each one, which is not the result that the 3 of us are getting. I think the problem is........., I don't' know! It has had me baffled for days.

  11. #11
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    With you gmr4evr1,all this does not make since.
    z

  12. #12
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    Tried a dozen codes for opening outlook and sending mail,they all work.But put a vbaproject password on them they all open outlook behind workbook.I do not understand why the password would
    cause this.Different people try the example workbook and works perfect with or without password.Tried example on laptop with new excel install and have same problems,All ideas are welcome on
    a possible fix to this. My computer is windows7 64 bit running 32 bit office2013,my labtop is windows7 32bit running office 2013 32 bit. Missing something simple here I think,just can't get a finger on it.Maybe someone that tried it and saved with a different password can post that workbook with password and will try that.I will try anything right now.

  13. #13
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,773

    Re: VBA ProjectPassword

    The common factor still seems to be Office 2013.

    Will see if I can get someone else to look at it.

    Regards, TMS

  14. #14
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,213

    Re: VBA ProjectPassword

    Works fine for me in 2013 and Windows 10

  15. #15
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA ProjectPassword


  16. #16
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    Thanks gmr4evr1 for the test,same results on my end. My goal in life will get this to work no matter how long it takes. All this does not make since,different machines and different results.
    Z

  17. #17
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA ProjectPassword

    Someone, somewhere somehow, there is an answer....At least I hope there is.

  18. #18
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    LOL I want to Thank all you guy's for your help,it has to be something on my end.Going to set up another computer with all new installs. This will take some time but I will post back,I will not
    sleep right and loosing a lot of hair over this.I'm not good at vba but know how it should work,Again Thank You.
    Z
    New Windows7
    New Office 2013

  19. #19
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA ProjectPassword

    You're welcome, and again, good luck.

  20. #20
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    Well set up new computer from scratch,newly formatted drive. Installed Windows7 and Office 2013. Ran the example file and all is the same.?? I must be missing something,installed all the office tools with Excel and Outlook.Should I try a Microsoft forum for help,is there one? This hole thing is making me a lot older.LOL.Could it be I live in Michigan and there is something in the air? About to give up and take this to my grave as not solved.

    Z

  21. #21
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,530

    Re: VBA ProjectPassword

    I live in Michigan and there is something in the air?
    You are probably closer to the magnetic North Pole than the rest of us. It's probably magnetic field related. Drive to Texas and see if the problem goes away.

  22. #22
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA ProjectPassword

    .....Drive to Texas and see if the problem goes away
    I'm here waiting for y'all

  23. #23
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    Have posted problem on other forums,will let you know if a fix is found.Will stay on top of this so I don't waste anyone's time. Thank You


    http://www.excelforum.com/excel-prog...tpassword.html
    http://www.mrexcel.com/forum/excel-q...tpassword.html

  24. #24
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,172

    Re: VBA ProjectPassword

    Fix is in place. Hope this might help someone down the road.
    http://www.ozgrid.com/forum/showthread.php?t=196515



    Please Login or Register  to view this content.

  25. #25
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: VBA ProjectPassword

    YAY! I'm glad you were able to get it resolved. Now we can all sleep peacefully again.

  26. #26
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,773

    Re: VBA ProjectPassword

    Ditto. Thanks for the update and code. Tried it and it works for me ... though I guess I didn't have the problem in the first place.

    That said, always interesting to have new examples, particularly late binding.

    Regards, TMS

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1