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

"vvv" wrote:

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