how to create a zoom butom in vba excel

V

vvv

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a default zoom in Infopath 0
(Word 2016/365) Removing white space between pages at a smaller zoom 0
Dynamic Naming of Form Button 3
Program buttons to create a word document 0
I figured out the issue thank you. 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Two lines in one in one line - How to do 2
How to zoom in VBA 4

Top