how to create a zoom butom in vba excel

  • Thread starter Thread starter vvv
  • Start date Start date
V

vvv

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

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

how to create a zoom butom in vba excel 2
Can anyone recommend a good third party plug-in for Zoom closed captioning? 1
How to zoom in VBA 4
Zoom in/Zoom out picture 1
zoom in &zoom out in VBA User Form 0
PageSetup.Zoom=TRUE 3
zoom in on range 1
adjust zoom according to sheet 3

Back
Top