Suppress File Name
 

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.

Suppress File Name
 

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.

Suppress File Name
 

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.

Suppress File Name
 

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!

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.

Suppress File Name
 

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.

Suppress File Name
 

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!