header/footer from page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BorisS - 13 Dec 2005 06:10 GMT

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?

Signature

Boris

Reply to this Message

Paul B - 13 Dec 2005 11:56 GMT

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

Signature

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

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

Reply to this Message