Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
zoom settings
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
zoom settings
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
zoom settings
Am new to VBA - could you pls show me how to do it for all sheets in
workbook thxs Bob Phillips wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
zoom settings
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) "al007" wrote in message ps.com... Am new to VBA - could you pls show me how to do it for all sheets in workbook thxs Bob Phillips wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
zoom settings
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 Bob Phillips wrote: 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) "al007" wrote in message ps.com... Am new to VBA - could you pls show me how to do it for all sheets in workbook thxs Bob Phillips wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zoom and view settings reverting after download from a website | Excel Discussion (Misc queries) | |||
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. | Excel Discussion (Misc queries) | |||
ZOOM | Excel Worksheet Functions | |||
zoom | Excel Programming | |||
Zoom value | Excel Programming |