Hi Jim,

so if you change the window you get a new caption. This
happens if you open a new workbook or...

Quite true and so, according to requirements, the workbook's activate and
deactivate events can be used.

The OP should also note that these settings are not persistent between Excel
sessions.


---
Regards,
Norman


"Jim Thomlinson" wrote in
message ...
Thanks. I never even thought to look there. I learned something new or
just
completely forgot about it... The only caveat is that the application
caption
sticks to the instance of excel where as the activewindow caption sticks
to
the active window so if you change the window you get a new caption. This
happens if you open a new workbook or...
--