How To Display Header/Footer in View

[Guest]

I am trying to display at least the header in an excell spreadsheet when
viewing the worksheet (I want the view to look the same as the printed
version).

Please help!

Thanks
cjaaron

 

[Guest]

You need to use File/Print Preview
Bob Umlas, Excel MVP

 

[Guest]

Thanks Bob, I am aware of File/Print Preview but I was looking for a way to
display the logo's that I have placed in the Header when opening this
spreadsheet - not everyone will print this file or display it in print
preview...any suggestions??

Agan TIA for your help!
cjaaron

 

[Guest]

Can easily be done as you wish in the upcoming Excel 2007. Meanwhile, you can
force the user into a print preview when the workbook opens by this code
(right-click the excel LOGO near the file menu & select View Code & paste
this in:
Private Sub Workbook_Open()
Me.PrintPreview
End Sub

 

[Guest]

A WHOO HOO goes out to you Bob - Yes that seems to be working!!!

cjaaron