ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File Name Display (https://www.excelbanter.com/excel-discussion-misc-queries/123265-file-name-display.html)

J Mowad

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

galimi

File Name Display
 
Go to your IDE & type

application.caption = ""
--
http://HelpExcel.com




"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?
--
Johnny Mowad


Gord Dibben

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com