Thanks, Lonnie!

That seemed the logical choice, but when I checked the Excel help files it
kept referring to changing the zoom for printing. VBA's help file leave a lot
to be desired.

Thanks again for your help!

"Lonnie M." wrote:

> Hi, ActiveWindow.Zoom = 85 would set the zoom to 85%.
> In the VBA editor if you press F2 it will bring up a search window to
> search the VBA libraries for built in functions, properties, and
> methods. This is very helpful to find things like this.
>
> HTH--Lonnie M.
>
>