The title bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
 
Back
Top