Fixed Sheet size

[wmtsub]

Is it possible to force a worksheet to always open to a specified size and location and not influence the next worksheet that opens?

 

[onlyadrafter]

Hello,

One way would be to put this code into every worksheet code window

Private Sub Worksheet_Activate()
    ActiveWindow.Zoom = 75
    Range("c3").Select
End Sub

change as necessary.

Is this what you require?

 

[wmtsub]

That might work but can rather than in % can i specify the actual size?