new window event

[John]

Hi

xl2003. Does anyone know how I can get an event to fire when the user opens
a new window ?

'withevents' in a class module offers activate, deactivate and resize but no
other likely suspects.

Any help, advive or pointers gratefully received.

Many thanks
John

[Bob Phillips]

Try saving all the application window captions on startup, and each time a
window is activated, check against your list (array). If found, ignore, if
not its new so do your stuff and add it.

Maybe it would be best to check all windows on any activate, in case one is
closed.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" <nonone@nowhere.com> wrote in message
news:1152284065.405902@smtp-1.griffin.com...
> Hi
>
> xl2003. Does anyone know how I can get an event to fire when the user
opens
> a new window ?
>
> 'withevents' in a class module offers activate, deactivate and resize but
no
> other likely suspects.
>
> Any help, advive or pointers gratefully received.
>
> Many thanks
> John
>
>

[John]

Thanks Bob, nice workaround!

"Bob Phillips" <bob.NGs@somewhere.com> wrote in message
news:ed5ZjgdoGHA.4828@TK2MSFTNGP04.phx.gbl...
> Try saving all the application window captions on startup, and each time a
> window is activated, check against your list (array). If found, ignore, if
> not its new so do your stuff and add it.
>
> Maybe it would be best to check all windows on any activate, in case one
> is
> closed.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "John" <nonone@nowhere.com> wrote in message
> news:1152284065.405902@smtp-1.griffin.com...
>> Hi
>>
>> xl2003. Does anyone know how I can get an event to fire when the user
> opens
>> a new window ?
>>
>> 'withevents' in a class module offers activate, deactivate and resize but
> no
>> other likely suspects.
>>
>> Any help, advive or pointers gratefully received.
>>
>> Many thanks
>> John
>>
>>
>
>