Jul 09 2022 01:13 PM - edited Jul 09 2022 01:32 PM
Jul 10 2022 09:04 AM
So you could generate page previews for each individual sheet...insert code in a VBA button.
Option Explicit
Sub Print_Preview()
With ActiveSheet.PageSetup
ActiveWindow.SelectedSheets.PrintPreview
'ActiveSheet.PageSetup.PrintArea = "A1:AH60" 'only if you like to see only specific area
End With
End Sub