Disable zoom

A

Al

Hi,
Is there a bit of programming I can add to this to disable
any further zoom once a WB opens at 100%?

Sub Zoom_freeze()
ActiveWindow.Zoom = 100
End Sub

Thanks
 
F

Frank Kabel

Hi
don't think this is possible. You may add some code to the
sheetactivate event to set the zoom always to 100% again then enabling
a sheet
 
Top