Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change data of entire column from small case to upper case | Excel Worksheet Functions | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
Advised file is open when not the case | Excel Discussion (Misc queries) |