View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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