Suppress File Name
It worked! Thank you very much Norman.
"Norman Jones" wrote:
Hi Francis,
Try:
ActiveWindow.Caption = ""
---
Regards,
Norman
"Francis Ang" wrote in message
...
Is there a way to suppress the file name appearing the title bar of a
workbook using VBA? I know how to change the description appearing in the
title bar by using 'Application.Caption="My Description"' but cannot
suppress
the file name.
Any help is very much appreciated.
Thanks.
|