View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LauriS LauriS is offline
external usenet poster
 
Posts: 32
Default Copying headers and footers between sheets

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