Why did you have to set the zoom level on the workbook open event? I have
never seen the zoom level change spontaneously. Was this a problem (zoom
level changes of its own accord), ill behaved users or just overcautious? .


--
Regards,
Tom Ogilvy


"gocush" /delete wrote in message
...
I don't know if this helps but some of the apps I have built require, or
at
least appear best with different zoom values for each sheet. During the
Wbk_Open event I set ScreenUpdating to False, activate each sheet and set
its
zoom, then continue with other code. The zoom value of each sheet remains
until changed again.

"Glen Mettler" wrote:

I can change the zoom value of a window with:
ActiveWindow.Zoom = 75

Is it possible to change the value of another sheet without activating
it?
Sheets("MySheet").zoom = 75 does not work

Glen