how to create a zoom butom in vba excel

[vvv]

hey guys how do I create a button (vba code) that upon each click changes the
zoom of the workshet?

 

[BSc Chem Eng Rick]

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"
<><><><><><><><><><>