Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Recording a macro in EXCEL that will record mouse clicks

  Asked By: Jeff    Date: Sep 20    Category: MS Office    Views: 1637
  

I would like to be able to record a macro in excel that will also
record the mouse clicks on a number of check and option boxes that i
have on my spreadsheet. Can anyone help

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Taylor Evans     Answered 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

 
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: