Excel - The title bar

Asked By Pietr

22-Jun-07 02:55 AM

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

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

Thanx

22-Jun-07 04:04 AM

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

22-Jun-07 04:43 PM

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 <Pietro@>