Excel Header questions

  • Thread starter Thread starter James KA
  • Start date Start date
J

James KA

Howdy all,

I have a question for you all, we want to put our company logo on an
excel spread sheet but only on page 1. When we insert the header it
puts it on all of the pages. Does anyone know how to stop this from
happening?
 
James

Only through VBA unless you print out just the first page in one print job then
the rest of pages in second print job.

See Ron de Bruin's site for VBA code.

You will have to adapt his code for your situation but easily done.

http://www.rondebruin.nl/print.htm#Header


Gord Dibben MS Excel MVP

Howdy all,

I have a question for you all, we want to put our company logo on an
excel spread sheet but only on page 1. When we insert the header it
puts it on all of the pages. Does anyone know how to stop this from
happening?

Gord Dibben MS Excel MVP
 
How about just putting it at the top of the spreadsheet (i.e. the top of
page 1) and forgetting about headers?

Craig
 
Back
Top