I dont know if it can be locked but this will set zoom to 100% each time the
sheet accessed
Put it in the sheet module

Private Sub Worksheet_Activate()
Windows(1).Zoom = 100
End Sub



"ExcelMonkey" wrote in message
...
How do you lock the zoom level of a sheet?

Thanks