using VBA to print Header & footer

Discussion in 'Microsoft Excel Discussion' started by, Nov 28, 2011.

  1. Guest

    What VBA code should I use in a worksheet so it will print a header &
    , Nov 28, 2011
    1. Advertisements

  2. Don Guillett Guest

    Have you tried doing it manually while recording a macro...??
    Don Guillett, Nov 28, 2011
    1. Advertisements

  3. Guest

    I recorded a macro but it did not show it when print preview or when

    To explane the idea more:
    If I go to the page setup menu, header & Footer and add the custom
    header i want, it stays there and can be seen when printing it.

    Can these steps be done using VBA code?
    , Nov 29, 2011
  4. Guest

    Thanks Dave,
    I am almost there.
    My left header is a picture (\stone\L_Logo.tif) and is in the same
    folder as the Excel file.
    I did not succeed to have the picture shown!
    How can it be done? What should I put after the equal sign in
    the .LeftHeader line?
    , Nov 30, 2011
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.