I need to triger and event when switching between 2 window programs.

for example:

I have a windows program open and an excel spreadsheet open. I want t
triger an event when I switch from the first windows program to m
excel spreadsheet.

I have tryed:

Private Sub WindowActivate()

but this will only work when switching between 2 excel windows.

Any help you can give would be great!

Thank

--
Message posted from http://www.ExcelForum.com