When I open an Excel document that I have previously saved the title of the
workbook is no longer appearing in the title bar. What can I do to make the
title reappear in the title bar?

Do you mean the Title Bar where you normally see Microsoft Excel - workbook.xls?

You just see Microsoft Excel - and that's all?

Do you have any workbook_open code that turns off the caption name?

Like ActiveWindow.Caption = ""


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 15:04:01 -0800, ManhattanRebel
wrote:

When I open an Excel document that I have previously saved the title of the
workbook is no longer appearing in the title bar. What can I do to make the
title reappear in the title bar?

Thank you for the help.

Yes, top middle of page where you normally see Microsoft Excel. That is all
I see now. I use to see the file name I gave the file at the top op the
window when I opened the file but it is no longer there.

What is workbook open code? To my knowledge there is none.



"Gord Dibben" wrote:

Do you mean the Title Bar where you normally see Microsoft Excel - workbook.xls?

You just see Microsoft Excel - and that's all?

Do you have any workbook_open code that turns off the caption name?

Like ActiveWindow.Caption = ""


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 15:04:01 -0800, ManhattanRebel
wrote:

When I open an Excel document that I have previously saved the title of the
workbook is no longer appearing in the title bar. What can I do to make the
title reappear in the title bar?

With your workbook open and visible, right-click on the Excel Icon left of
"File".

Select "View code".

Anything in that module?


Gord

On Mon, 26 Nov 2007 18:21:01 -0800, ManhattanRebel
wrote:

Thank you for the help.

Yes, top middle of page where you normally see Microsoft Excel. That is all
I see now. I use to see the file name I gave the file at the top op the
window when I opened the file but it is no longer there.

What is workbook open code? To my knowledge there is none.



"Gord Dibben" wrote:

Do you mean the Title Bar where you normally see Microsoft Excel - workbook.xls?

You just see Microsoft Excel - and that's all?

Do you have any workbook_open code that turns off the caption name?

Like ActiveWindow.Caption = ""


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 15:04:01 -0800, ManhattanRebel
wrote:

When I open an Excel document that I have previously saved the title of the
workbook is no longer appearing in the title bar. What can I do to make the
title reappear in the title bar?

Thanks for the help..

I have Excel 2007.. I do not see "file" when I open it. I right clicked on
the only Excel Icon I see but I don't see a "view code" option when I do that.

"Gord Dibben" wrote:

With your workbook open and visible, right-click on the Excel Icon left of
"File".

Select "View code".

Anything in that module?


Gord

On Mon, 26 Nov 2007 18:21:01 -0800, ManhattanRebel
wrote:

Thank you for the help.

Yes, top middle of page where you normally see Microsoft Excel. That is all
I see now. I use to see the file name I gave the file at the top op the
window when I opened the file but it is no longer there.

What is workbook open code? To my knowledge there is none.



"Gord Dibben" wrote:

Do you mean the Title Bar where you normally see Microsoft Excel - workbook.xls?

You just see Microsoft Excel - and that's all?

Do you have any workbook_open code that turns off the caption name?

Like ActiveWindow.Caption = ""


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 15:04:01 -0800, ManhattanRebel
wrote:

When I open an Excel document that I have previously saved the title of the
workbook is no longer appearing in the title bar. What can I do to make the
title reappear in the title bar?

I do not use 2007 so not sure where all the features are located.

See Ron de Bruin's site for a map of 2007 commands.

http://www.rondebruin.nl/0307commands.htm

And where code resides.

http://www.rondebruin.nl/code.htm


Gord

On Tue, 27 Nov 2007 07:07:04 -0800, ManhattanRebel
wrote:

Thanks for the help..

I have Excel 2007.. I do not see "file" when I open it. I right clicked on
the only Excel Icon I see but I don't see a "view code" option when I do that.

"Gord Dibben" wrote:

With your workbook open and visible, right-click on the Excel Icon left of
"File".

Select "View code".

Anything in that module?


Gord

On Mon, 26 Nov 2007 18:21:01 -0800, ManhattanRebel
wrote:

Thank you for the help.

Yes, top middle of page where you normally see Microsoft Excel. That is all
I see now. I use to see the file name I gave the file at the top op the
window when I opened the file but it is no longer there.

What is workbook open code? To my knowledge there is none.



"Gord Dibben" wrote:

Do you mean the Title Bar where you normally see Microsoft Excel - workbook.xls?

You just see Microsoft Excel - and that's all?

Do you have any workbook_open code that turns off the caption name?

Like ActiveWindow.Caption = ""


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 15:04:01 -0800, ManhattanRebel
wrote:

When I open an Excel document that I have previously saved the title of the
workbook is no longer appearing in the title bar. What can I do to make the
title reappear in the title bar?