View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Francis Ang[_3_] Francis Ang[_3_] is offline
external usenet poster
 
Posts: 75
Default 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.