Changing/Editing Excel's Application Caption (RESOVLED)

[Daniel McCool]

I want to make the titlebar in Excel to include anything I specifiy. I have tried (Application.Caption = "Hello World") but this does not work. Any help? Thanks.

[adocwra]

it works but the workbook name is appended

[Daniel McCool]

Thanks for confirming this. It wasn't working because I wasn't passing a variable to the function :( *sigh*