Excel Header questions

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

 

[Gord Dibben]

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

 

[cschiller1]

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

Craig