On the Task Bar, can I display the workbook title when minimized .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I change what is displayed on the task bar from "Microsoft Excel...." to
the workbook file name?
 
Gerry

Can use macro for changing the Title Bar.

Note: does not stick between sessions so must be re-done when Excel opens the
workbook.

Private Sub Workbook_Open()
Application.Caption = " "
ActiveWindow.Caption = ActiveWorkbook.Name
End Sub

Right-click on the Excel logo at top left of Menubar and select "View Code".

Paste in there.

Save the workbook.

I would suggest you place this code in your Personal.xls so's it changes the
setting each time Excel is opened.

There are a few other settings for the Title Bar if you are interested.

Don't ask me how to get rid of the Excel Logo.


Gord Dibben Excel MVP
 
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

change the displayed title so 'microsoft exel' is not in it 2
Excel MS Excel in Win 10 3
Document name not displayed in Title Bar 1
How do I display the worksheet name in the title bar for Excel? 2
Excel Unlink open excel files 2
Excel 2007 Workbook Small Vertical Bar Next to "X" 1
Scroll problem 2
When I minimmize Outlook it disappears from the task bar. 7

Back
Top