how to create a zoom butom in vba excel

  • Thread starter Thread starter vvv
  • Start date Start date
V

vvv

hey guys how do I create a button (vba code) that upon each click changes the
zoom of the workshet?
 
Just insert the button on the spreadsheet and assign the following macro to
it. This macro will always zoom to 75% but you can set whatever you want.

Sub ZoomSheet()
ActiveWindow.Zoom = 75
End Sub

If this helps please click "Yes"
<><><><><><><><><><>
 
Back
Top