Change Excel Titlebar

[Todd Bardoni]

I know I've seen it before on this board, but after about an hour and a half of looking I can't find how to change the Excel Title bar. Please help. Thanks.

 

[Todd Bardoni]

I should say that I want to change the text, not the format.

 

[Mudface]

Do you mean something like this, for the active workbook: -

ActiveWindow.Caption = "TBardoni's Text"

 

[Todd Bardoni]

Man, I was so close but yet so far...that's what I need...thanks.

I've got to study my VBA more...