Zoom and Scroll of InactiveWindow

[exceere]

Hi,

i Know how can i get the ZOOM and SCROLL of Active window: By Using the following code

With ActiveWindow
    RowScr = .ScrollRow
    ColScr = .ScrollColumn
    WinZom = .Zoom
End With

But, how can i get the ZOOM and the SCROLL values of inactive window (or window of inactive sheet)?

 

[Useful]

Hello!

Workbooks("workbook_name").Sheets("sheet_name").Activate
with activewindow
'
'
'
end with

 

[exceere]

Thank you USEFUL,

Can i do this without Activating the inactive Sheet?

 

[VoG]

Cross posted ZOOM and SCROLL of Inactive Window

Please read Excelguru Help Site - A message to forum cross posters

 

[exceere]

Thank you VoG for your advise

I didn't Know the Cross posted before

but now i know that from you

thank you again

 

[exceere]

now i know how to avoid the cross posted, and this is what i posted in other forum

http://www.excelforum.com/excel-pro...22633-zoom-and-scroll-of-inactive-window.html