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
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
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
>.
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks