View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default How to make Excel the Top-Most application programmatically?

I don't think you can do this. The closest you can come is to use

AppActivate Application.Caption

This will cause the Excel icon in the Taskbar to blink, but won't
actually make the application active.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"R Avery" wrote in message
...
I have Excel checking a file every so often for a particular

command,
and whenever it finds a certain command, I want it to bring

Excel to the
front and prompt the user.

Similarly, I would like to be able to send Excel to the back

whenever
some other command was inside a file.

How could I achieve this? Any help would be appreciated.