moving page breaks in a group of sheets

[Guest]

I have several worksheets in a file that need to be formatted the same. I
have selected all the pages (grouped), click view, page break preview. What
I need is to be able to just move the page break lines by just clicking and
dragging. I can do this with only one sheet selected, but when I have a
group, then is will not let me. It also will not let me reset all page
breaks. I have done this before but can not figure out why sometimes it
works and sometimes it doesn't. Anyone know how to fix this? Any ideas or
suggestions are GREATLY appreciated as I have spent time and time again on
this as well as referencing the web and books and have found no solution.
Thanks in advance for any help
Shelia

 

[Gord Dibben]

Sheila

You may be mis-remembering that you "did it before".

That is one of the several functions that cannot be done to grouped sheets.

A couple more are setting the print range and rows to repeat at top.

VBA code is required for all three functions.

See this google thread for some info on setting printrange and rows to repeat at
top.

http://snipurl.com/106kz

Pagebreaks could be done the same way.


Gord Dibben MS Excel MVP