Suppress File Name

[Guest]

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.

 

[Frank Kabel]

Hi
don't think ou can do this with plain VBA. This would require some Windows
API calls

 

[Norman Jones]

Hi Francis,

Try:

ActiveWindow.Caption = ""

 

[Sharad]

The application Title Bar consists of Application.Caption &
Window.Caption.
So you set Application.Caption to what you want. After that you need to
set Window.Caption to blank ("").
e.g.

Dim W
For each W in Application.Windows
W.Caption = ""
Next W

Sharad

 

[Guest]

It worked! Thank you very much Norman.

Hi Francis,

Try:

ActiveWindow.Caption = ""

 

[Guest]

Thank you for trying and your time.

Hi
don't think ou can do this with plain VBA. This would require some Windows
API calls

 

[Guest]

Thanks Sharad for the help.