vbe command for making excel in the active window on top

P

pls123

i need exactly that !!!

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

tx !
 
P

pls123

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

txxx
 
D

Dave Peterson

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

pls123

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
 
P

pls123

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

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top