Workbook Title Line
Excel 2000 -
I have a workbook that I was able to change the Title box from "Microsoft Excel" to "Company" - however, is there a way of removing the name of the file that appears beside it "ex - "ZZZ.xls""? Also, the newsgroup is an excellent place to answer question, but is there a web site that provides examples and answers? Thanks for any help, Greg |
Workbook Title Line
Greg
Private Sub Workbook_Open() Application.Caption = "Company" ActiveWindow.Caption = "" End Sub These settings will not stick, so must be in the Thisworkbook module of the workbook that is opened, or in Personal.xls which opens with Excel. Gord Dibben Excel MVP On Wed, 29 Dec 2004 16:35:35 -0800, "Greg Malenky" wrote: Excel 2000 - I have a workbook that I was able to change the Title box from "Microsoft Excel" to "Company" - however, is there a way of removing the name of the file that appears beside it "ex - "ZZZ.xls""? Also, the newsgroup is an excellent place to answer question, but is there a web site that provides examples and answers? Thanks for any help, Greg |
Workbook Title Line
Thanks Gord, works great!
Sometimes the hardest problems have the easiest answers. Greg -----Original Message----- Greg Private Sub Workbook_Open() Application.Caption = "Company" ActiveWindow.Caption = "" End Sub These settings will not stick, so must be in the Thisworkbook module of the workbook that is opened, or in Personal.xls which opens with Excel. Gord Dibben Excel MVP On Wed, 29 Dec 2004 16:35:35 -0800, "Greg Malenky" wrote: Excel 2000 - I have a workbook that I was able to change the Title box from "Microsoft Excel" to "Company" - however, is there a way of removing the name of the file that appears beside it "ex - "ZZZ.xls""? Also, the newsgroup is an excellent place to answer question, but is there a web site that provides examples and answers? Thanks for any help, Greg . |
All times are GMT +1. The time now is 09:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com