header/footer from page

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top