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.

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" schrieb im Newsbeitrag
...
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.

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.

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!

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.

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" schrieb im Newsbeitrag
...
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.

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!