raison d'etre

I have often found bits and snippets of code on the web that I have incorporated into things I'm working on. I take no responsibility for these code samples. Most of them have been laboriously gleaned off of the web, but they're real handy to have quick access to. So bookmark this and enjoy...

JovialJohn

Tuesday, May 4, 2010

Set Zoom

Sometimes you might want to change the zoom on the page, this one is really easy.

     Sheets("Sheet1").Select
     Range("A1").Select
     ActiveWindow.Zoom = 75

I arbitrarily select A1 to show from the top of the spreadsheet.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)