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?
|