seagull
seagull

Reputation:

excel-2007 zoom in zoom out

hi is it possible to write something like zoom-in and zoom-out button...

for example i will have a userform on which i will have two buttons one for each zoom in and out... whenever the user clicks on one of the buttons plus user clicks the cells (or selects the range) that cell or range will be increased or decreased using the ActiveWindow.Zoom option....

if this is possible plz can you tell me how? thanks a lot!

Upvotes: 1

Views: 712

Answers (1)

devuxer
devuxer

Reputation: 42384

Try ActiveWindow.Zoom = 50 within your VBA. That will set your zoom to 50%.

Upvotes: 1

Related Questions