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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerry_gas - 17 Feb 2005 15:21 GMT

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

Reply to this Message

anonymous@discussions.microsoft.com - 17 Feb 2005 20:24 GMT

hi,
what are you calling the task bar?

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

Reply to this Message

Gord Dibben - 17 Feb 2005 22:03 GMT

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

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

Reply to this Message