Renaming the Excel windows taskbar

  • Thread starter Thread starter easylife
  • Start date Start date
E

easylife

Hi,
Would appreciate if someone could tell me how one can change the way Excel
displays different file windows on the TaskBar and how one can rename it to
how the sheetname or how one could just rename it in a worksheet to suit
oneself. If there is an add-in that would help. EL2003.

Thanks
 
Hi Eirinberg,
Thanks but it did not work or mayb I didn't do it right.

Went into VBA project and created a new procedure as

' Public Sub Caption()
Sub SetApplicationCaption()
Application.Caption = Range("A1").Value
End Sub

but nothing happened. Could you please carry me through the
process....thanks in advance..Regards
 
what's in A1 and did you run the code?


easylife said:
Hi Eirinberg,
Thanks but it did not work or mayb I didn't do it right.

Went into VBA project and created a new procedure as

' Public Sub Caption()
Sub SetApplicationCaption()
Application.Caption = Range("A1").Value
End Sub

but nothing happened. Could you please carry me through the
process....thanks in advance..Regards
Click to expand...
 
Culpa Mia! Yes it works but what I was really looking for was the Windows of
XL which opens in the windows task bar...how does one change that!

Thanks
 
Back
Top