Header & Footer

[ExcelNovice]

Not sure this is possible, but who knows:

I want to include in the Header (using Page Setup or macro) the ability to use info in the spreadsheet.
Example, I want the Header to say, today's top sales category is T-Shirts. "T-Shirts" would be pulled from cell C4, so the Header should always pull the content of cell C4.

Is this possible?
Thanks

 

[Yogi Anand]

You can use the following code to enter the header in the center panel

Sub HeaderFromCellEntry()

' Macro -- 10/5/02 by Yogi Anand for Header from a cell entry
'
     ActiveSheet.PageSetup.CenterHeader = "Today's Top Category is " & [C4]
End Sub

Regards!

Yogi
This message was edited by Yogi Anand on 2002-10-05 19:10

 

[ExcelNovice]

Thanks Yogi, but I can't get this to work...maybe I'm doing something wrong, but its not working.

 

[Yogi Anand]

On 2002-10-06 00:17, ExcelNovice wrote:
Thanks Yogi, but I can't get this to work...maybe I'm doing something wrong, but its not working.

The macro that I posted earlier has to be run for the Page Header to include the entry from cell C4.

If you want to have it automated such that whenever you print that sheet, it will use your customized header (including the entry from cell C4), then you can put the code in ThisWorkbook's BeforePrint event ...

Private Sub Workbook_BeforePrint(Cancel As Boolean)
' Macro -- 10/5/02 by Yogi Anand for Header from a cell entry
'
     ActiveSheet.PageSetup.CenterHeader = "Today's Top Category is " & [C4]
End Sub

Please post back if it works for you ... otherwise explain a little further and let us take it from there.

Regards!

Yogi