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.
Printable View
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.
it works but the workbook name is appended
Thanks for confirming this. It wasn't working because I wasn't passing a variable to the function :( *sigh*