Multiple windows of single file display on windows taskbar

E

easylife

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....
 
J

Jacob Skaria

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
 
E

easylife

Hi Jacob,
Thanks for your reply and yes I meant the same. But to clarify, I wish to
Icon at the bottom windows task bar to mention the sheetnames instead of the
file name and window number....
 
Top