Can VBA running in a background window bring itself to the foreground 1

[vamoose]

I have an Excel 2000 sheet using VBA to refresh itself at set intervals throughout the day. Can VBA be used to bring this sheet to the foreground, active window, if someone places it in the background ? Thanks for any input or advice.

 

[PHV]

You may try this:
Application.WindowState = xlNormal

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vamoose]

Tried your code PHV but this does not bring it forward if placed in the background. Somehow can you set the Active window to Excel("VPD.xls") and bring it forward as well ?
Thanks

 

[PHV]

And this ?
AppActivate Application.Caption

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vamoose]

Ooh, that works, thanks a million.