Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jeff Cunningham   on Sep 20 In MS Office Category.

  
Question Answered By: Taylor Evans   on Sep 20

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

Share: 

 
 
Didn't find what you were looking for? Find more on Recording a macro in EXCEL that will record mouse clicks Or get search suggestion and latest updates.


Tagged: