Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Change Title Bar

Is it possible to change the title bar when I open a worksheet, at
present it says Microsoft Excel - and the worksheet name.

I would prefer it to just have the worksheet name or anything else that
I want

--
praptisahni
------------------------------------------------------------------------
praptisahni's Profile: http://www.excelforum.com/member.php...fo&userid=8569
View this thread: http://www.excelforum.com/showthread...hreadid=517328


Post your answer or comment

comments powered by Disqus
I have an Excel file with various userforms created in VBA. Is there a way to change the format (specifically, the color) of the title bars?

Thanks in advance.

Hi there,

Is it possible to change a user form title bar colour from the default blue?

Thanks in anticipation

Red

Hi,

Situation: I open Excel 2002 (XP), choose a file to open (eg
"myfile.xls") and work in it.

I save a copy via File / Save as. I name it "mynewfile.xls" and click
OK.

File correctly saved; the original still exists on disk. The filename
appears correctly in the File menu in the list of recently used files.

But: the information in the Excel's title bar didn't change: it still
displays the filename of the first file.

If I understand Excel well, it saves a copy of the original file to a
new one, and keeps working with the new one. So the new filename
should appear in the title bar.

I continue working in the new file; I close Excel, open it and open
the copy (mynewfile.xls), all changes I made after the first "save as"
are well kept and saved, and now, Excel displays the correct filename
in the title bar.

Has anyone an idea how to correct the issue with the title bar
information which isn't changing after a "save as"?

I use Excel XP SP3 English (10.6713.6735) and have full local admin
access on my PC / all xls files are stored locally.

thanks in advance for any reply, information, tip or solution!

Dominic

Hi,

Situation: I open Excel 2002 (XP), choose a file to open (eg
"myfile.xls") and work in it.

I save a copy via File / Save as. I name it "mynewfile.xls" and click
OK.

File correctly saved; the original still exists on disk. The filename
appears correctly in the File menu in the list of recently used files.

But: the information in the Excel's title bar didn't change: it still
displays the filename of the first file.

If I understand Excel well, it saves a copy of the original file to a
new one, and keeps working with the new one. So the new filename
should appear in the title bar.

I continue working in the new file; I close Excel, open it and open
the copy (mynewfile.xls), all changes I made after the first "save as"
are well kept and saved, and now, Excel displays the correct filename
in the title bar.

Has anyone an idea how to correct the issue with the title bar
information which isn't changing after a "save as"?

I use Excel XP SP3 English (10.6713.6735) and have full local admin
access on my PC / all xls files are stored locally.

thanks in advance for any reply, information, tip or solution!

Dominic

Hi all,

I have searching furiously all morning and have had no luck finding a code to work properly.

I am trying to create a real "program feel" to the project I am working on, and want to know if it even possible to use my own icon that i have created. I have relocated the file to
"C:WindowsSystem32LabTech1.ico", but can relocate if needed.

I have been able to make one code change the Title Bar Icon to Notepad (but I have to assume that is considered childs play to most of you at this point), and I tried fruitlessly to modify it to suit my needs.

I have a user that would like to see the full path name of a file in Excel in
the Title Bar. Is there any way to change it from just the file name to the
full path name?

Instead of the Title bar indicating "Microsoft Office Excel 2003 Book 1" it
simply states "Microsoft Office Excel"
I have a blue bar between the column bar and the formula bar which does
indicate the open file (Book 1). For training purposes I would like to change
to the format where the title bar indicates the open file.
How do I do that?

Oh wise ones,

Is it possible to display the value of a cell in the Excel title bar or the
system tray. You can see what I'm getting at, monitoring the value of a cell
while excel is minimized. This value is constantly changing every 2 seconds
from a sheet calculation macro, so the Title/Tray would have to change
dynamically.

Mike

Using Excel 2002 SP3. I have been working with an excel file with the same
file name and path for several years. Today suddenly when I opened the file,
the file name on the title bar has [Group] after the name. I also noticed at
the same time that several of the formula cells are not getting updated
properly until I go to the cell and edit it (making no changes) then it shows
the correct value. [ I hit F2 to edit then return with no changes and then
the values display properly.].

Does anyone what this [group] at the end of the file name in the title bar
means? It is only happening with this one file....

Thanks for any help you can provide!

The syntax for Excel for the msgbox is quite similar to
AutoIt's (a freeware scripting program). When I create
message boxes in AutoIt, I can put a "title" or header
info in the title bar of the box.

I've searched various pages on the net looking for syntax
similar to this but for Excel but I haven't seen anything
that shows if this is even possible. If it can be done,
what would the syntax be, pls?

My line of coding looks like this currently:

MsgBox "Getting ready to print ... please insert a pink
sheet of paper into the printer."

I'd like to put the "Getting ready to print ..." in the
title bar if possible.

Also, while doing the abovementioned searching, I did find
a neat piece of code that adds a red circle with an X
through it and this "icon" is added through
the "vbcritical" coding at end of the revised line here:

MsgBox "Getting ready to print ... please insert a pink
sheet of paper into the printer.", vbCritical

I'm thinking the one with a yellow triangle "caution" sign
with an exclamation point would be better for this. Is
this possible; and if so, does anyone know the syntax for
it?

Thanks so much! As always, this is for the benefit of
many people. Cheers. :oD

Does anyone know if it possible to change the excel icon located in the title bar at the top of the screen, to another icon?

Phil S

Hi all,
Does anyone have a vba code to change the color of the title bar of
excel.
(I already have code to change it for all the windows)
Thanks for your help

Hi is there any way that i can remove the excel title bar and scrolling tabs so that the excel sheet do not resemble an excel document? Thanks b4

i am able to remove the title bar but unable to move the userform now.
plzz help .....

Hi there,
I want to create a sheet which should just be partly used to support another application. I dont want people to find out where this sheet is located, but as it is sometimes in use, you can see its name in the title bar. Therefore I wanted to clean up the title bar/name in the toolbar at the botton.

I found some posts showing how to add something there, but nothing how to clear it totally, also in the windows toolbar at the bottom.

thanks,

markus

Hi,

does anyone know how to remove the title bars on userforms? I cant work it out for the life of me, thanks

Rich

A colleague asked me today if I knew what it meant when the word "Group" appears in the title bar. The word appears in the same place that "Read-Only" or "Shared" appears when you have opened the spreadsheet in read on ly mode or have shared the workbook. Does anyone know? I think it might have to do with using a shared workspace.... but I really don't know.

Hi All,

I am building an application and want to force users to administer via a userform. Using the web I've developed various components (e.g. Chip Pearson's disabling of Max/Min icons) but one problem remains.

Even with the Workbook protected, double clicking the Excel - not Workbook - Title Bar enables the Ribbon.

Possibly it's a sequencing issue. Have searched for a suitable fix; any thoughts would be welcomed.

Cheers,
David

The workbook name does not appear in the title bar for Excel. How can I set
it up to do so?

Does any one know how to hide the title bar in VBA code for Excel 2007, the code for 2003 Excel doesn't hide everything in 2007. I just want to see cells on the screen. I can do this in 2003 VBA, but 2007 version is killing me.

Help please,

Nestle

I type this code into my workbook and I trying to avoid typing every single toolbar option. Is there an easier code to hide all toolbar options & formula bar, but only show the title bar?

Sub Workbook_activate()
On Error Resume Next
With Application
.CommandBars("Worksheet Menu Bar").Enabled = False
.CommandBars("Standard").Visible = False
.CommandBars("Formatting").Visible = False
.CommandBars("Control Toolbox").Visible = False
End With
On Error GoTo 0
End Sub

Private Sub Workbook_Deactivate()
On Error Resume Next
With Application
.CommandBars("Worksheet Menu Bar").Enabled = False
.CommandBars("Standard").Visible = True
.CommandBars("Formatting").Visible = True
.CommandBars("Control Toolbox").Visible = True
End With
On Error GoTo 0
End Sub

Good morning/evening!

I was wondering if there are any ways to alter the type of title bar on a userform window, or better still, remove it completely? Is this a shell patch maybe?

thx

Any way of changing scroll bar's color so that it stands out? thanks

I'd like to be able to disable the right-click menu when clicking on the active window title bar.

I've checked this site for a solution but none seem to apply to the title bar, just within the worksheet itself

The right click menu doesn't appear when the window is Maximised, but does otherwise, i.e when multiple windows are tiled or cascaded,and that is when I wish to disable the menu.


No luck finding an answer? You could always try Google.