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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top