Prev: Locked problem when using .Clear
Next: Copy varaible no. of rows to another woorkbook
From: Dave Peterson on 5 May 2010 20:34
I've seen tweaks to windowsXP Home (I think) that allow you to set the number of
blinks -- but I'm not sure if that allows your code to activate a different
window.

I'm betting that you're going to need some API calls (way beyond me).

If I needed this, I'd either search google in the VB (not VBA groups). Or post
a question in one of the VB groups. Explain that you want to accomplish this
from Excel's VBA. Include your version of windows and Office.

You could search Randy Birch's VBNet at: http://mvps.org/
or go directly: http://vbnet.mvps.org/

Good luck.



pls123 wrote:
>
> not yet dave !
> i need to have the excel window ,
> active..and on top..not maximized..but on top..
> and with the bar on the top of the window in the "active " colour..
>
> because when it is not i have a different cpu usage..
>
> tx anyway!
> paolo
>
> "Dave Peterson" wrote:
>
> > To allow another program to just take focus doesn't seem very well behaved to
> > me.
> >
> > And I think that this depends on the version of windows or a setting in
> > windows. Some setting/version (I don't recall which) will only flash the icon
> > in the taskbar.
> >
> > But maybe...
> >
> > AppActivate Application.Caption
> >
> > ===
> > If you meant that you wanted excel always on top, then search google for program
> > called DeskPins. It can work with any program. It's a manual process, though.
> >
> >
> > pls123 wrote:
> > >
> > > pleasee i need the
> > > vbe command for making excel the active window on top of each other window !
> > >
> > > txxx
> > >
> > > "pls123" wrote:
> > >
> > > >
> > > > i need exactly that !!!
> > > >
> > > > the vbe command for making excel in the active window on top..
> > > >
> > > > tx !
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2
Prev: Locked problem when using .Clear
Next: Copy varaible no. of rows to another woorkbook