View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
veryeavy veryeavy is offline
external usenet poster
 
Posts: 72
Default How can I copy print options from one tab to another tab?

Hi Sean,

What Gord says <grin.

I use the following technique to quickly apply a standard footer to any new
worksheet.

Record a macro with the footer (and other settings as required) as you want
it.

Assign the macro to a custom button (the button with a coupla footprints
fitted the bill for me).

Push button when required.

Now I must get round to making a "clear standard footer" button ...

Cheers,

Matt