Case of the missing file name
 

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.

Case of the missing file name
 

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.

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.