How To Display Header/Footer in View

C

cjaaron

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
 
C

cjaaron

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
 
B

Bob Umlas, Excel MVP

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
 
Top