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

"vvv" wrote:

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