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
--
easylife

Hi there,

Try the following:

Sub SetApplicationCaption()
Application.Caption = Range("A1").Value
End Sub
--
A. Ch. Eirinberg


"easylife" wrote:

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
--
easylife

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
--
easylife


"Howard31" wrote:

Hi there,

Try the following:

Sub SetApplicationCaption()
Application.Caption = Range("A1").Value
End Sub
--
A. Ch. Eirinberg


"easylife" wrote:

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
--
easylife

what's in A1 and did you run the code?


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


"Howard31" wrote:

Hi there,

Try the following:

Sub SetApplicationCaption()
Application.Caption = Range("A1").Value
End Sub
--
A. Ch. Eirinberg


"easylife" wrote:

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
--
easylife

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
--
easylife


"Patrick Molloy" wrote:

what's in A1 and did you run the code?


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


"Howard31" wrote:

Hi there,

Try the following:

Sub SetApplicationCaption()
Application.Caption = Range("A1").Value
End Sub
--
A. Ch. Eirinberg


"easylife" wrote:

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
--
easylife