Automatic Zoom

[Markus]

How can I use vb to automatically set the view to zoom at
40 percent when a sheet is activated?

Thanks

 

[Bob Phillips]

Markus,

This is likely to make it unviewable, but here it is

Sub Auto_Open()
ActiveWindow.Zoom = 40
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Roger Whitehead]

Copy the following code to the Activate event of the worksheet.

ActiveWindow.Zoom = 40