Zoom level

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%)

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
--
Kevin Backmann


"Fotis" wrote:

> 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%)