How to zoom in VBA
When in doubt of syntax, record a macro while doing it manually. You should
get a result like
Sub Macro1()
ActiveWindow.Zoom = 70
End Sub
HTH. Best wishes Harald
"Jim" wrote in message
...
I want to zoom the page out like 70% like when you go to View -- Zoom
--70%. How do i write it in VBA? I know PageSetup has the zoom for
printing,
I tried it but doesnt actually zoom the sheet. Any help will be much
appreciated! Thanks
|