Microsoft Office Forums - View Single Post - ZOOM and SCROLL of Inactive Window

Thread: ZOOM and SCROLL of Inactive Window

View Single Post

Old

07-05-2014, 08:50 PM

exceere

exceere is offline

exceere uses Windows 7 64bit

Windows 7 64bit exceere uses Office 2007

exceere uses Office 2007

Office 2007

Novice

The original poster

Join Date: Jun 2014

Posts: 7

exceere is on a distinguished road

Default

ZOOM and SCROLL of Inactive Window

Hi,

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

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)?

Reply With Quote