ZOOM and SCROLL of Inactive Window

exceere · #1 07-05-2014, 08:50 PM

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

whatsup · #2 07-08-2014, 12:34 PM

Hi

hm, difficult, maybe with some magic API, but you also can do it by using a workaround:

Code:

Sub Workaround()
Dim RowScr As Long
Dim ColScr As Long
Dim Winzom As Long

Application.ScreenUpdating = False
Sheets(2).Activate
With ActiveWindow
    RowScr = .ScrollRow
    ColScr = .ScrollColumn
    Winzom = .Zoom
End With
Sheets(1).Activate

Application.ScreenUpdating = True

MsgBox "RowScr: " & RowScr & vbCrLf _
    & "ColScr: " & ColScr & vbCrLf _
    & "WinZom: " & Winzom
    
End Sub

exceere · #3 07-09-2014, 02:33 AM

thank you very much Whatsup

your try it acceptable

but, can i get the window informations from inactive sheet without activating it?

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inactive tasks and resource usage view	codeghi	Project	1	05-05-2014 06:59 AM
New Contact Group Icon is Gray - Inactive	kdfrancis	Outlook	0	04-09-2014 10:53 AM
Finding the Selection in an inactive worksheet	BobBridges	Excel Programming	4	09-30-2013 02:03 PM
Page does not actively scroll with click, hold and drag on scroll-bar	jbax	Word	1	05-09-2013 07:16 PM
Options Buttons become inactive	clint	Word	0	02-25-2010 04:31 PM