vbe command for making excel in the active window on top

  • Thread starter Thread starter pls123
  • Start date Start date
P

pls123

i need exactly that !!!

the vbe command for making excel in the active window on top..

tx !
 
pleasee i need the
vbe command for making excel the active window on top of each other window !

txxx
 
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.
 
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
 
tx sorry for repeating !

Dave Peterson said:
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.
Click to expand...
 
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.
 
Back
Top