V vvv Oct 8, 2009 #1 hey guys how do I create a button (vba code) that upon each click changes the zoom of the workshet?
B BSc Chem Eng Rick Oct 8, 2009 #2 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" <><><><><><><><><><>
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" <><><><><><><><><><>