changing the application name in the title bar
Paul
Vasant gave you the code for this but must be noted that this is not a
permanent change and has to be re-done each time you close out and re-start
Excel.
Place the code into a Thisworkbook Workbook_Open Sub or a General Module
Auto_Open Sub.
Gord Dibben Excel MVP
On Mon, 22 Dec 2003 13:55:19 -0800, "Paul James"
wrote:
I once read there was a way to change the name of an application as it
appears in the Excel title bar. That is, to replace the "Microsoft Excel -
filename.xls" with whatever name you want to use.
I tried using "Application.Name = "my application name" but I got the error
message "Can't assign to read-only property." Is there a way to accomplish
this?
Thanks in advance
Paul
|