header/footer from page

[Guest]

is there a way to have a header/footer reference values that are on a sheet?
I have some novice users, for who I'd like to make a very easy to fill in
area of information, and then have the headers and footer of sheets appear
nicely formatted with their information in there.

Any way?

 

[Paul B]

BorisS, here is one way using a before print event,

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.RightFooter = Range("A1")
End Sub

Put in thisworkbook code

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003