LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Case of the missing file name

Thanks Gord,
No the title bar was not visible.
It was eventually fixed by right clicking on excel icon at base of
screen and clicking on restore (XP).
Seems to have done the trick
regards Mick
A baby sitter is a teenager acting like an adult while the adults are out
acting like teenagers.

"Gord Dibben" wrote:

Is the blue TitleBar visible?

Can you see "Microsoft Excel" but no workbook name?

Run this macro to get the filename back.

Sub show()
ActiveWindow.Caption = ActiveWorkbook.Name
End Sub

But I would suggest you try to find out what piece of code was responsible
for the problem in the first place

This line of code would turn it off.

ActiveWindow.Caption = ""

Maybe you have some workbook that did this.


Gord Dibben MS Excel MVP

On Sun, 8 Feb 2009 15:10:02 -0800, MickBarry
wrote:

Hi ,
Recently my excel 97 workbook names have gone missing at the top of my
screen.
Any suggestion as to how to bring it back
regards Mick
Tomorrow's a mystery.
Today is a gift.
That's why we call it the present.



 
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
change data of entire column from small case to upper case Ann Excel Worksheet Functions 1 August 16th 08 01:06 PM
Changing multiple cell text from lower case to upper case Patti Excel Discussion (Misc queries) 2 January 4th 08 08:35 PM
Changing file in all upper case to upper and lower case Sagit Excel Discussion (Misc queries) 15 May 30th 07 06:08 AM
Change the text from lower case to upper case in an Excel work boo dave01968 Excel Discussion (Misc queries) 2 December 9th 05 09:09 AM
Advised file is open when not the case deniseh Excel Discussion (Misc queries) 1 November 3rd 05 01:37 PM


All times are GMT +1. The time now is 03:59 PM.

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"