Try something like

ActiveWindow.Zoom = 75


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dstiefe" wrote in message
...
how do I change the "zoom" from 100% to 75%?

thank you