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
 
Back
Top