Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where's my title bar? | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
Title in row 1 | Excel Discussion (Misc queries) | |||
Show full path title in title bar? | New Users to Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |