Workbook Title Line

  • Thread starter Thread starter Greg Malenky
  • Start date Start date
G

Greg Malenky

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
 
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
 
Thanks Gord, works great!

Sometimes the hardest problems have the easiest answers.

Greg
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to remove Workbook window title bar? Or other ways toarrange multiple workbook windows. 4
Strange behavior 3
Unwanted workbooks on startup 2
Changes in How Code Acts After Upgrade of Excel 2
How to split an excel workbook in code and data 2
Repeat the titles across multiple sheets of a workbook. 6
Excel 95 equivalent of modern events? 6
link multiple tabs in new worksheet 3

Back
Top