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

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" wrote in message
...
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

Thanks Bob, nice workaround!

"Bob Phillips" wrote in message
...
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" wrote in message
...
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