Copy Page Breaks

[jwleonard]

Thanks Dave, I have been manually setting the page breaks on eac
worksheet. I was hoping for a way to set them on the first sheet an
then copy those breaks to all remaining sheets in one step. I hav
tried to find a way but obviosly I was unsuccessful, I was hopin
someone with more experince would know of a way. I am pretty sure VB
would be the only way.

If copying isn't an option then would it be possible to create a macr
that would allow me to insert the rows where I wanted page breaks an
the loop through all the worksheets? I am picturing a message box tha
would ask for the rows seperated by commas that I would like to put th
breaks before. I have tried this and it didn't work, however, I hav
limited experience with message boxes and page breaks in VBA (mostly
have just messed with ranges and sheet protection). I guess my rea
question now is does it sound like this idea would work or am I wastin
my time trying to figure it out

 

[Dave Peterson]

Ahhh.

I thought you were working with a single worksheet.

If you group your worksheets and then insert the page breaks, what happens.
(Click on the first worksheet tab and control click on subsequent)

And when you're done, rightclick on any of the grouped and select "ungroup
sheets"

(Almost anything you do to grouped sheets will affect all in the group--nice for
pagebreaks, not so nice for deleting rows (say).)