#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default File Name Display

At the very top, left-hand corner of the Excel screen there is displayed the
"Excel Logo" then "Microsoft Excel" then the "File Name". How do you
eliminate "Microsoft Excel" from the display?
--
Johnny Mowad
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default File Name Display

You can get rid of the Microsoft Excel part completely and just show the
filename.

Private Sub Workbook_Open()
Application.Caption = " "
End Sub

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

Right-click on the Excel logo left of "File" on menu and select "View Code"

Paste the above into that module.


Gord Dibben MS Excel MVP


On Wed, 20 Dec 2006 07:51:01 -0800, J Mowad
wrote:

At the very top, left-hand corner of the Excel screen there is displayed the
"Excel Logo" then "Microsoft Excel" then the "File Name". How do you
eliminate "Microsoft Excel" from the display?


Gord Dibben MS Excel MVP
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I display custom file properties in a cell Glen Perry Excel Discussion (Misc queries) 4 November 20th 06 05:59 PM
need to export row as csv file with column e plus .bom as file name rod Excel Discussion (Misc queries) 5 November 2nd 06 03:38 AM
importing a particular excel worksheet into another excel file dinouk Excel Worksheet Functions 0 August 10th 06 02:03 PM
Display name of imported data file coa01gsb Excel Worksheet Functions 2 March 21st 06 06:40 PM
Can I write an excel formula to display the file save date? Bob-123456789 Excel Worksheet Functions 1 January 26th 06 07:50 PM


All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"