View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?