Title for Excel Document
 

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?

Title for Excel Document
 

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?

Title for Excel Document
 

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?

Title for Excel Document
 

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?

Title for Excel Document
 

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?

Title for Excel Document
 

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?