Caption Confusion

Richie(UK)

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
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
 
Sort by date Sort by votes
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
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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?
 
Upvote 0
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?
 
Upvote 0
You must log in or register to reply here.

Similar threads

X
  • Question Question
Remove filename only on title bar & not also on taskbar item?
Replies
0
Views
778
xunil76
X
steve case
  • Question Question
Opening an already open Excel file crashes the system
Replies
4
Views
418
steve case
steve case
6StringJazzer
  • Question Question
Constantly getting "Out of memory" messages when VBA window is open
Replies
7
Views
2K
6StringJazzer
6StringJazzer
I
  • Solved
In Excell VBA the set variable change without clear reason
Replies
5
Views
146
Micron
M
D
  • Question Question
Tally that shifts cells daily.
Replies
3
Views
1K
portews
P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top