PC Review


Reply
Thread Tools Rate Thread

How do I get the same header/footer to print on each page of a wo.

 
 
=?Utf-8?B?U3RlcGhlbiBDb25ub2xseQ==?=
Guest
Posts: n/a
 
      17th Mar 2005
I've made a custom header / footer how do I get it to print on each page of a
work book without having to re-create on each page
--
Stephen Connolly
 
Reply With Quote
 
 
 
 
Jason Morin
Guest
Posts: n/a
 
      17th Mar 2005
Group the worksheets by clicking the first worksheet tab,
hold down the <Shift> key, and click the last worksheet
tab. Now set up the header under File > Page Setup.

To ungroup, click any one of the worksheet tabs, or right-
click one of them and select "Ungroup".

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I've made a custom header / footer how do I get it to

print on each page of a
>work book without having to re-create on each page
>--
>Stephen Connolly
>.
>

 
Reply With Quote
 
=?Utf-8?B?UGV0ZXIgUm9vbmV5?=
Guest
Posts: n/a
 
      17th Mar 2005
Stephen,

You could record a new macro with you going into the Header/Footer dialog
for the sheet that contains the footer you want to copy
This will create a macro which, because all its sheet references are to
"currentsheet" can easily be run against all your other sheets, too.

Thus:

1. Go into sheet containing footer
2. Record a new macro
3. Click View Header/Footer
4. Click OK
5. Stop recording
6. Click on a sheet that requires the header/footer details
7. Run the macro.
8. repeat Steps 6-7 for all sheets that need modifying.

Hope this helps

Pete

"Stephen Connolly" wrote:

> I've made a custom header / footer how do I get it to print on each page of a
> work book without having to re-create on each page
> --
> Stephen Connolly

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: HOW DO I NOT PRINT PAGE FOOTER ON A GROUP HEADER PAGE? =?Utf-8?B?RHVhbmUgSG9va29t?= Microsoft Access Reports 2 30th Dec 2006 03:33 AM
How to change header/footer programmatically for page print in IE Gabriel Lozano-Morán Microsoft ASP .NET 2 5th Aug 2005 02:32 PM
Print header or footer instead of banner page? Hannes Printers 0 30th Jun 2005 08:35 PM
print header or footer on first page only =?Utf-8?B?bmFkaW5lcA==?= Microsoft Excel Misc 2 11th Dec 2004 05:25 PM
print asp page without header and footer ashj Microsoft ASP .NET 0 24th Jun 2004 05:54 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:22 AM.