Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Excel Header questions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
James KA - 03 Jul 2006 16:15 GMT
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?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.