Renaming the Excel windows taskbar
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 |
Renaming the Excel windows taskbar
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 |
Renaming the Excel windows taskbar
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 |
Renaming the Excel windows taskbar
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 |
Renaming the Excel windows taskbar
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 |
All times are GMT +1. The time now is 11:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com