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 - 03 Jul 2006 21:10 GMT
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<at>earthlink.net - 03 Jul 2006 22:25 GMT
How about just putting it at the top of the spreadsheet (i.e. the top of
page 1) and forgetting about headers?
Craig
> 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?