zoom settings

  • Thread starter Thread starter al007
  • Start date Start date
A

al007

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
 
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)
 
A bit more info would help. When and how do you decide what zoom setting you
want to use, and when and how do you want to change the other sheets?



--

HTH

RP
(remove nothere from the email address if mailing direct)
 
When I "duplicate" a workbook with new window, the sheets in the"new"
workbook are zoomed at 100% unlike the "original" workbook with sheets
having different zoom settings.
That's why I wanted to have same zoom settings for all sheets in new
workbook same as original workbook.
Guess it would be quite difficult to have a macro for such a solution.?

Thxs
 
Back
Top