Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Excel title bar

Status
Not open for further replies.
HelgeLarsen

HelgeLarsen

Programmer
Mar 18, 2004
16
DK
The taskbar shows the text from the title bars of all windows.

If several documents are open in Word, the taskbar shows:
Document1.doc - Microsoft Word
Document2.doc - Microsoft Word
etc.
With an auto-hidden taskbar positioned to the left it is easy to choose the correct document since its name is clearly shown.

With several workbooks open in Excel the taskbar shows:
Excel - WorkBook1.doc
Excel - WorkBook2.doc
etc.
Here it is not that easy to find the correct workbook - unless I use a very wide taskbar.

Therefore my question is:
=========================
How can I change the Excel title bar so that it only holds the name of the workbook, or at least starts with it?

Something like:
WorkBook1.doc - Excel
WorkBook2.doc - Excel
etc.






________________________
Helge Larsen
 
Sort by date Sort by votes
What is your excel version? At least in xp, when you tick 'show windows in taskbar' (tools > options > view tab) the status bar will display only workbooks' names.
You can programmatically remove 'excel' from the window title (only: '- WorkbookName.xls' remains) after macro:
Application.Caption=" "
If you like it, create simple add-in with Workbook_Open event procedure and above code inside.

combo
 
Upvote 0 Downvote

To avoid too much cluttering I normally do not check 'Show Windows in Taskbar'.

I had hoped for a registry change like:
Code: 
[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
"Window Title"="HVL"
which changes the IE6 title bar to:
<HTML page title> - HVL

By the way: I'm using Excel 2003 SP2 and Windows XP Prof. vers. 2002 SP2.

Helge


________________________
Helge Larsen
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
295
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
291
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
867
shytott
shytott
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
656
SoftwareRT
SoftwareRT
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
304
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top