To my knowledge clicking leads to setting values and those values you can
set in code. For example: setting the page setup
==> Mac1 set the page to fot on 1 page
==> MAc3 set the page to fit to a max of 3 page3
Sub Macro1()
With ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With
End Sub
Sub Macro2()
With ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 3
End With
End Sub