update excel title bar

[christhedonstar]

Hi,

How do you update the excel title bar text using VBA?

Thanks,

Chris

 

[combo]

Application.caption ' replace 'Excel',
Workbooks(NameOrIndex).Windows(1).Caption ' replace workbook's name displayed.


combo

 

[christhedonstar]

Not sure what you meant so tried this:

Application.Caption = "The stuff I want to put for a certain workbook"

Problem is when I hit ctrl tab and it goes to another workbook (not produced by me) the caption stays. Is the only way to get around this to trap some event to set application.caption = ""
??

Or have I misread/understood your suggestion?

Cheers,

Chris

 

[combo]

For maximized workbook the title bar combines application title ('Excel', independent from opened workbook) and workbook's window title (with workbook's name by default). The captions can be separated when you set workbook's window to normal.
To make application title workbook sensitive, you can use Workbook_WindowActivate/Workbook_WindowDeactivate events.

combo