I recorded a Macro to adjust the page breaks.
Sub Macro2()
' Macro2 Macro
ActiveWindow.SelectedSheets.PrintPreview
ActiveSheet.PageSetup.PrintArea = "$A$1:$H$25"
ActiveWindow.SelectedSheets.PrintPreview
End Sub
Try to run it and it stops at the Print Preview window. Click Page Break Preview and it continues and does the adjustment then goes back to Print Preview. You have to click on Normal View to get it to finish. What do you have to do to get to run all the way through???
Sub Macro2()
' Macro2 Macro
ActiveWindow.SelectedSheets.PrintPreview
ActiveSheet.PageSetup.PrintArea = "$A$1:$H$25"
ActiveWindow.SelectedSheets.PrintPreview
End Sub
Try to run it and it stops at the Print Preview window. Click Page Break Preview and it continues and does the adjustment then goes back to Print Preview. You have to click on Normal View to get it to finish. What do you have to do to get to run all the way through???