Worksheet size control

[Dan Wilson]

Good day. I am running Excel out of Office 365 on Windows 10. I have learned how to change the size of a worksheet on my screen to be able to see columns beyond AL11. In my macros I have also included commands to scroll up or down on an existing display. I notice in the macro that commands are present to accomplish that task. I have looked up Scale in Help, but I don't think that has anything to do with altering the view size of a worksheet. Is there a command that I can enter into a macro to change the view size of a worksheet to a generic value at the end of the macro to ensure that the size of a worksheet ends up at a preset value? I appreciate any help.
Thanks, Danno...

 

[mumps]

Try:

ActiveWindow.Zoom = 60

Change the number to suit your needs.

 

[Dan Wilson]

Good day mumps. Thank you for responding. I saw a couple of those commands in my macros after creating them. Thank you,
Danno...

 

[mumps]

You are very welcome.