View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default View filename - Excel 2007

Eric,

I too am new to E2007 but I'm not aware of any way to switch it off in E2007
without using code. There are various things you can do not limited too:-


Set things back to default
Application.Caption = ""

display the name
Application.Caption = ActiveWorkbook.Name

Display the path and name
Application.Caption = ActiveWorkbook.FullName

Put your own text in

Application.Caption = "You'll never walk alone"

Mike





"Eric_NY" wrote:

I've just upgraded to Excel 2007.

Excel 2003 used to have an option to display the name of the saved worksheet
file at the top of the screen. I'm sure Excel 2007 has this option, but I
can't figure out how to turn it on.

Can anyone help?

Thanks.