nagovind
Member
Dear all
I'm using this code to display the caption as ...as desired by me..so that Microsoft Excel will disappear..it is working
but it is not updating after i save the file as using Save as
how to code ..such that the NEW file name concatenated with my name has to be updated
ActiveWindow.DisplayHeadings = False
Application.DisplayFormulaBar = False
Windows(1).Caption = "[ & ThisWorkbook.Name & ]"
Application.Caption = "My Name"
I'm using this code to display the caption as ...as desired by me..so that Microsoft Excel will disappear..it is working
but it is not updating after i save the file as using Save as
how to code ..such that the NEW file name concatenated with my name has to be updated
ActiveWindow.DisplayHeadings = False
Application.DisplayFormulaBar = False
Windows(1).Caption = "[ & ThisWorkbook.Name & ]"
Application.Caption = "My Name"