Caption Confusion

Richie(UK) · May 24th, 2002, 05:17 PM

Hi all,

As most of you will know, its possible to put your own title in the blue bar at the top of the Excel window with the following code:

Application.Caption = "MyCaption"

However, the Excel filename then follows on after the caption. Is there anyway to stop this from happening?

Cheers, Richie

crt · May 24th, 2002, 05:47 PM

where do you put that code?

RET79 · May 24th, 2002, 05:52 PM

crt

Try putting it in the immediate window like I did.

RET79

crt · May 24th, 2002, 06:00 PM

? Where ?

RET79 · May 24th, 2002, 06:04 PM

Go to visual basic editor (if you are on excel press Alt&F11). Then press control&G and type the code in the window that pops up then press enter.

RET79

Tom Schreiner · May 24th, 2002, 06:36 PM

Hi Richie.
This will display the string you assign without any baggage..

Sub MsgOnly()
ActiveWindow.Caption = ""
Application.Caption = "Hello to all!"
End Sub

Output: Hello to all!

With no file or application name.

Tom

Richie(UK) · May 25th, 2002, 09:36 AM

Application.Caption = "Cheers Tom, just what I wanted!"

Richie

Morticcia · Feb 20th, 2003, 02:44 PM

Thought I'd piggy back my 'caption' question here. I'm trying to understand what caption means. I did a search on the text "activewindow.caption" and rec'd this thread as search result.

In reading the above posts, I am now of the opinion that "activewindow.caption" reads the bar at the top of the page (default color bule?) for the name of the active wiindow file name? Am I close?

Morticcia · Feb 20th, 2003, 02:46 PM

Thought I'd piggy back my 'caption' question here. I'm trying to understand what caption means. I did a search on the text "activewindow.caption" and rec'd this thread as a search result.

In reading the above posts, I am now of the opinion that "activewindow.caption" reads the bar at the top of the page (default color blue?) for the name of the active wiindow file name? Am I close?

Morticcia · Feb 20th, 2003, 02:46 PM

Thought I'd piggy back my 'caption' question here. I'm trying to understand what caption means. I did a search on the text "activewindow.caption" and rec'd this thread as a search result.

In reading the above posts, I am now of the opinion that "activewindow.caption" reads the bar at the top of the page (default color blue?) for the name of the active wiindow file name? Am I close?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 05:17 PM	#1
Richie(UK) MrExcel MVP Join Date: May 2002 Location: UK Posts: 3,333	Hi all, As most of you will know, its possible to put your own title in the blue bar at the top of the Excel window with the following code: Application.Caption = "MyCaption" However, the Excel filename then follows on after the caption. Is there anyway to stop this from happening? Cheers, Richie

May 24th, 2002, 05:47 PM	#2
crt New Member Join Date: May 2002 Posts: 11	where do you put that code?

May 24th, 2002, 05:52 PM	#3
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	crt Try putting it in the immediate window like I did. RET79

May 24th, 2002, 06:00 PM	#4
crt New Member Join Date: May 2002 Posts: 11	? Where ?

May 24th, 2002, 06:04 PM	#5
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	Go to visual basic editor (if you are on excel press Alt&F11). Then press control&G and type the code in the window that pops up then press enter. RET79

May 24th, 2002, 06:36 PM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Richie. This will display the string you assign without any baggage.. Sub MsgOnly() ActiveWindow.Caption = "" Application.Caption = "Hello to all!" End Sub Output: Hello to all! With no file or application name. Tom

May 25th, 2002, 09:36 AM	#7
Richie(UK) MrExcel MVP Join Date: May 2002 Location: UK Posts: 3,333	Application.Caption = "Cheers Tom, just what I wanted!" Richie

Feb 20th, 2003, 02:44 PM	#8
Morticcia New Member Join Date: Feb 2003 Posts: 39	Thought I'd piggy back my 'caption' question here. I'm trying to understand what caption means. I did a search on the text "activewindow.caption" and rec'd this thread as search result. In reading the above posts, I am now of the opinion that "activewindow.caption" reads the bar at the top of the page (default color bule?) for the name of the active wiindow file name? Am I close?

Feb 20th, 2003, 02:46 PM	#9
Morticcia New Member Join Date: Feb 2003 Posts: 39	Thought I'd piggy back my 'caption' question here. I'm trying to understand what caption means. I did a search on the text "activewindow.caption" and rec'd this thread as a search result. In reading the above posts, I am now of the opinion that "activewindow.caption" reads the bar at the top of the page (default color blue?) for the name of the active wiindow file name? Am I close?