+ Reply to Thread
Results 1 to 8 of 8
  1. #1
    Valued Forum Contributor
    Join Date
    05-15-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    797

    minimise instead of close

    Hello gurus.

    This may be a little complex, Though i am currently using a program by vboffice called olkeeper. This changes the X in the top right corner from close to minimise.
    Can this be done via the visual basics of oultook.
    Or would it need to be done on a system level VB.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,938

    Re: minimise instead of close

    There are many examples of how to apply Minimize buttons to a userform
    http://www.excelforum.com/search.php?searchid=1548455

    So if you can identify the form in order to get it's window handle it should be possible.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor
    Join Date
    05-15-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    797

    Re: minimise instead of close

    Not trying to add one to a userform.
    I mean it changes the X thats on nearly every windows program. Like the _ (resize) X buttions.
    A lot of people like me leave outlook on 24/7 and everynow and then (without olkeeper) by habbit click the close buttion. With olkepper it stopes the close to minimise.
    The only reason i ask is that i have been using this program on a trial and now the trial has run out. knowing you people are very smart in things like this though you may save me a few dollers.

    I probley shouldnt be so cheep, Especially now im starting to understand what go into programing somthink.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,938

    Re: minimise instead of close

    okay so not a userform but a windows form. The technique should work as long as you pass the API functions the correct information.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Valued Forum Contributor
    Join Date
    05-15-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    797

    Re: minimise instead of close

    I Dont realy know what i would be doing. Im a GreenHorn or 1 month in VB.
    So this is most likley out of my reach, Though i may have a tinkey around the net and see where it takes me. If i find the install file is there any way of opening it to see how they went about programing it, cos the same thing may come in handy to others where excel, word ect is opened 24/7. Beatuy sleep for now ill cheek back later.

    Goodnight.

  6. #6
    Valued Forum Contributor
    Join Date
    05-15-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    797

    Re: minimise instead of close

    Here what i got.
    olkeeper is a Delphi coded .exe.
    tryed to decomplie and other things with limited success, So ill tip my hat to the people that wrote the program.
    This thread can be deleted since its only taken up space on the server and serves no purpose.

    Thankyou.

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,938

    Re: minimise instead of close

    I found this on google which offers a non coded solution to the accidental Closure of Outlook.

    http://groups.google.com/group/micro...4c8a62cc25b7a8
    Cheers
    Andy
    www.andypope.info

  8. #8
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,126

    Re: minimise instead of close

    Nice link, Andy. Tillman's suggestion is simple and clever, and copied here lest the link die:
    Stick an unaddressed message in the Outbox. When you close Outlook it will tell you you have unsent messages and ask if you want to close.
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

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.2.0