Microsoft Excel
(1)
Workbook
(1)
PietroPrivate
(1)
Pietro
(1)
Sistence
(1)

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

The title bar

Asked By Mike
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

PietroPrivate Sub Workbook_Open()Application.

Asked By Gord Dibben
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@>
Post Question To EggHeadCafe