Taskbar name

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

How do I change the item's name shown on the TASKBAR to be the same as
the item's shortcut-name shown on the DESKTOP?

For example, an icon is labeled "EXCEL 2000" on the DESKTOP. But, on
the TASKBAR, the item is labeled "MICROSOFT EXCEL". How can I change
""MICROSOFT EXCEL" to "EXCEL 2000"?
 
Gary,

The Taskbar name get's set by the Title Bar Caption.
The icon can be labeled anything that you want as it has
nothing to do with the file. It's nothing more than a shortcut.
If the Title Bar says "Microsoft Excel - your file name",
the taskbar will say the the same.
The "Microsoft Excel" part of the that is the "Application.Caption"
and the filename is the "ActiveWindow.Caption"

You can experiment with these if you'd like.
Application.Caption = "Gary is the Greatest!!!!"
Activewindow.Caption = Thisworkbook.Name

or
Application.Caption = Thisworkbook.Name
ActiveWindow.Caption = ""

You could place the above in a sub named Auto_Open()
or in the workbook_Open event to have it change whenever
the workbook is opened.

Again, the above will change both the Title Bar and the TaskBar
button.

John
 
Back
Top