Save the Activewindow.Zoom property when the other workbook is nactive, and
then use that saved value to set the new activewindow. Note, you need to use
the window object not the workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"al007" wrote in message
oups.com...
How can I copy the sheets view zoom settings of a workbook of a new
window.
as all sheets are 100%
Want it to be the same as the previous window.
thxs