The title bar
 

Hi all,

I have a microsoft excel project that has the title "Customer
Support",but it appears in the upper part of the page "the blue one" as
"Microsoft Excel - Customer Support".

Is there a way to erase the word "Microsoft Excel" ?

Thanx

The title bar
 

Try this:-

probably best placed in the workbook_open event. From your description it
seems like you workbook is called Customer support which populates into the
title bar. This will delete the Microsoft Excel bit.

Sub sistence()
Application.Caption = ""
End Sub

Mike

"Pietro" wrote:

Hi all,

I have a microsoft excel project that has the title "Customer
Support",but it appears in the upper part of the page "the blue one" as
"Microsoft Excel - Customer Support".

Is there a way to erase the word "Microsoft Excel" ?

Thanx

The title bar
 

Pietro

Private Sub Workbook_Open()
Application.Caption = "Customer Support"
ActiveWindow.Caption = ""
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Caption = ""
ActiveWindow.Caption = ""
End Sub


Gord Dibben MS Excel MVP

On Thu, 21 Jun 2007 23:55:00 -0700, Pietro
wrote:

Hi all,

I have a microsoft excel project that has the title "Customer
Support",but it appears in the upper part of the page "the blue one" as
"Microsoft Excel - Customer Support".

Is there a way to erase the word "Microsoft Excel" ?

Thanx