Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 05-28-2009, 08:38 AM
D_Rennie D_Rennie is offline
Valued Forum Contributor
 
Join Date: 14 May 2009
Location: gold coast
MS Office Version:Excel 2007
Posts: 771
D_Rennie is very confident of their ability D_Rennie is very confident of their ability D_Rennie is very confident of their ability
minimise instead of close

Please Register to Remove these Ads

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.
Reply With Quote
  #2  
Old 05-28-2009, 08:46 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
 
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
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
Reply With Quote
  #3  
Old 05-28-2009, 08:59 AM
D_Rennie D_Rennie is offline
Valued Forum Contributor
 
Join Date: 14 May 2009
Location: gold coast
MS Office Version:Excel 2007
Posts: 771
D_Rennie is very confident of their ability D_Rennie is very confident of their ability D_Rennie is very confident of their ability
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.
Reply With Quote
  #4  
Old 05-28-2009, 09:09 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
 
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
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
Reply With Quote
  #5  
Old 05-28-2009, 09:44 AM
D_Rennie D_Rennie is offline
Valued Forum Contributor
 
Join Date: 14 May 2009
Location: gold coast
MS Office Version:Excel 2007
Posts: 771
D_Rennie is very confident of their ability D_Rennie is very confident of their ability D_Rennie is very confident of their ability
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.
Reply With Quote
  #6  
Old 05-29-2009, 08:08 AM
D_Rennie D_Rennie is offline
Valued Forum Contributor
 
Join Date: 14 May 2009
Location: gold coast
MS Office Version:Excel 2007
Posts: 771
D_Rennie is very confident of their ability D_Rennie is very confident of their ability D_Rennie is very confident of their ability
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.
Reply With Quote
  #7  
Old 05-29-2009, 09:00 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
 
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
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
Reply With Quote
  #8  
Old 05-29-2009, 11:51 AM
shg's Avatar
shg shg is online now
Forum Guru
 
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,547
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Re: minimise instead of close

Nice link, Andy. Tillman's suggestion is simple and clever, and copied here lest the link die:
Quote:
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.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump