Suppress File Name

[Francis Ang]

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Francis Ang" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> 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.

[Norman Jones]

Hi Francis,

Try:

ActiveWindow.Caption = ""

---
Regards,
Norman



"Francis Ang" <[email protected]> wrote in message
news:[email protected]...
> 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.

[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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Francis Ang]

It worked! Thank you very much Norman.

"Norman Jones" wrote:

> Hi Francis,
>
> Try:
>
> ActiveWindow.Caption = ""
>
> ---
> Regards,
> Norman
>
>
>
> "Francis Ang" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

[Francis Ang]

Thank you for trying and your time.

"Frank Kabel" wrote:

> Hi
> don't think ou can do this with plain VBA. This would require some Windows
> API calls
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
> "Francis Ang" <[email protected]> schrieb im Newsbeitrag
> news:[email protected]...
> > 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.
>
>
>

[Francis Ang]

Thanks Sharad for the help.

"Sharad" wrote:

>
> 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
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>