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)
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.