Copying Print Formats across multiple worksheets

  • Thread starter Thread starter SteveJ
  • Start date Start date
S

SteveJ

Does anyone know if there is way to format mulitple
worksheets with "Page Setup" functions. For example, I
want all sheets to be landscape, with rows 1 & 2 in the
Print Titles, etc.
I haven't had success selecting mulitple sheets and trying-
-won't let me. Also, when attempting a macro it wants to
stay referenced to the specific sheet in which it was
developed..but I'm not great at macros and can't program
VB to save my life.

Any help is appreciated.
Thanks,
 
Hi
if you group the sheets (hold down the SHIFT key while selecting the
sheets) you should be able to change the pagesetup for all these
sheets. What error did you receive then trying this
 
When grouping the sheets Frank, the setting to repeat rows and columns is
*not* copied, which is one of the settings the OP is trying to duplicate,
together with changing the page orientation from portrait to landscape,
which *is* duplicated.

I guess he'll need code, which is not my ball of wax, but is in your realm.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Hi
if you group the sheets (hold down the SHIFT key while selecting the
sheets) you should be able to change the pagesetup for all these
sheets. What error did you receive then trying this
 
Hi Frank-
I'm not getting an error message, but the Print Titles
area is "greyed-out" (unavailable for input); and I can't
inset page breaks in page preview view when multiple
sheets are selected.

Unfortunately I can't even format one sheet and then
create new ones by holding control and draggng the tab
because I'm using an add-in that interates a data pull and
autimatically creates new sheets. So I'm really looking
for a way to either copy a printing format from one to
many sheets or create a macro that is transferable accross
sheets.

Thanks,
 
I just got a macro to work to accoplish what I want.
But if you know of an easier way to format multiple
sheets, I'd still appreciate it.
Either way, thanks much.
 
Back
Top