+ Reply to Thread
Results 1 to 2 of 2

header/footer from page

  1. #1
    BorisS
    Guest

    header/footer from page

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

  2. #2
    Paul B
    Guest

    Re: header/footer from page

    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

    "BorisS" <BorisS@discussions.microsoft.com> wrote in message
    news:BEB205BA-13B9-4EE1-A117-69996B5D7D1A@microsoft.com...
    > 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?
    > --
    > Boris




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1