Changing title from default
Thanks. I never even thought to look there. I learned something new or just
completely forgot about it... The only caveat is that the application caption
sticks to the instance of excel where as the activewindow caption sticks to
the active window so if you change the window you get a new caption. This
happens if you open a new workbook or...
--
HTH...
Jim Thomlinson
"Norman Jones" wrote:
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
|