Setting Zoom according to User on a network
 

Is it possible to set a Zoom level when opening a workbook, but the user on
a network?

How can i code it if able?

--
Regards
Corey

Setting Zoom according to User on a network
 

this may work:

Private Sub Worksheet_Activate()
If UCase(Environ("UserName")) = "COREY" Then ' put the login name here
ActiveWindow.Zoom = 85
Else

ActiveWindow.Zoom = 100
End If

End Sub

--


Gary


"Corey" wrote in message
...
Is it possible to set a Zoom level when opening a workbook, but the user on a
network?

How can i code it if able?

--
Regards
Corey