Thread: Zoom value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Zoom value

Even though retained with the sheet, Zoom is a property of the window
object - so the answer would be no to the best of my knowledge.

--
Regards,
Tom Ogilvy

"Glen Mettler" wrote in message
...
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