Change Excel Title Bar/Caption
Do you mean you get the filename on the customised workbook?
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"AJ" wrote in message
...
Bob Thanks for code, it worked partially.
I still get the File name.xls How can I remove the file name?
Is it possible to remove the Excel Symbol/icon image?
I hope I am not asking for too much.
"Bob Phillips" wrote:
Private Sub Workbook_Activate()
Application.Caption = "my custom title"
End Sub
Private Sub Workbook_Deactivate()
Application.Caption = Empty
End Sub
Private Sub Workbook_Open()
Application.Caption = "my custom title"
End Sub
'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)
"AJ" wrote in message
...
Hello
How can I change the title "Microsoft Excel - File Name.xls" to custom
title
when I launch a particular work book. This change should occur only if
I
launch this work book. If I launch any other excel work book then the
normal
should occur i.e. "Microsoft Excel - File Name.xls"
Thanks in advance for your help.
BR
|