Zoom level

F

Fotis

I would like to know if it is possible to open a workshhet alway to the same
same zoom level (i.e 94%) no matter if i am closing it to a different one
(i.e 105%)
 
K

Kevin B

In the worksheet module that you want to revert to 94% you can place the
following code in the worksheets activate event:

Private Sub Worksheet_Activate()

ActiveWindow.Zoom = 94

End Sub
 
Top