PC Review


Reply
Thread Tools Rate Thread

Copying headers and footers between sheets

 
 
LauriS
Guest
Posts: n/a
 
      31st Jan 2008
Is this possible? User has a workbook with multiple sheets already set up.
They want to copy the header and footer from one of the sheets to all other
sheets.

I'd like to set it up so that it prompts them for the sheet with the h/f to
be copied and then asks which other sheet(s) to copy it to.

I don't want the actual code (like to struggle through that myself) - just a
helpful shove in the right direction.

Lauri
 
Reply With Quote
 
 
 
 
LauriS
Guest
Posts: n/a
 
      31st Jan 2008
Forgot to mention - I'm using version 2000.


"LauriS" wrote:

> Is this possible? User has a workbook with multiple sheets already set up.
> They want to copy the header and footer from one of the sheets to all other
> sheets.
>
> I'd like to set it up so that it prompts them for the sheet with the h/f to
> be copied and then asks which other sheet(s) to copy it to.
>
> I don't want the actual code (like to struggle through that myself) - just a
> helpful shove in the right direction.
>
> Lauri

 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      31st Jan 2008
The header and footer is part of the PageSetup. Rather than copy, you could
just use the same PageSetup code for each sheet. This code would put the
header on all sheets. You can work from there.

For i = 1 To Sheets.Count
Sheets(i).PageSetup.CenterHeader = "&"Arial" &12 HeaderText"
Next

"LauriS" wrote:

> Forgot to mention - I'm using version 2000.
>
>
> "LauriS" wrote:
>
> > Is this possible? User has a workbook with multiple sheets already set up.
> > They want to copy the header and footer from one of the sheets to all other
> > sheets.
> >
> > I'd like to set it up so that it prompts them for the sheet with the h/f to
> > be copied and then asks which other sheet(s) to copy it to.
> >
> > I don't want the actual code (like to struggle through that myself) - just a
> > helpful shove in the right direction.
> >
> > Lauri

 
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
can you set up global headers & footers for all sheets in a file? Donna Microsoft Excel Misc 2 24th Oct 2008 07:05 PM
Can I duplicate headers and footers on multiple sheets? =?Utf-8?B?SGVhdGhlckRCZWNlcnJh?= Microsoft Excel Worksheet Functions 2 13th Apr 2007 09:12 PM
headers/footers =?Utf-8?B?U2FkaWU=?= Microsoft Excel Misc 1 21st Sep 2005 04:12 PM
headers and footers across sheets mark Microsoft Excel Misc 2 21st Oct 2004 07:23 PM
Re: headers & footers Rick Brandt Microsoft Access Queries 0 11th Sep 2003 05:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:28 AM.