View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Changing title from default

Hi Jim,

The file name is going to stay no matter what you do (IIRC),


ActiveWindow.Caption = "My Replacement for Filename"


---
Regards,
Norman



"Jim Thomlinson" wrote in
message ...
The file name is going to stay no matter what you do (IIRC), but the
Microsoft Excel thing can be changed...

Sub Test()
Application.Caption = "Tada"
End Sub
--
HTH...

Jim Thomlinson