Do you mean

Activesheet.name
which gives you the current sheetname

and
Activewindow.Caption
which gives you the current workbook name

If this post helps click Yes
---------------
Jacob Skaria


"easylife" wrote:

Hi,
I wish there was a way of knowing which sheet was being used in a particular
window icon on windows tab instead of the default "FileName" :WindowNumber.
If there is an Addon that would help..
Thanks....
--
easylife