+ Reply to Thread
Results 1 to 3 of 3

How to make the same range displayed in each sheet I switch to in my workbook

  1. #1
    Registered User
    Join Date
    12-07-2006
    Posts
    5

    How to make the same range displayed in each sheet I switch to in my workbook

    Hi
    I have a workbook of 6 Sheets, what i want is that if i scrolled or zoomed one of the sheets i want all other sheets to be scrolled and zoomed accordingly identically.

    to explain more: say I'm on "sheet1" and I scrolled down so i'm seeing range(K225:X250), now if i switched to any of the other sheets i want them all scrolled to the same range. so whatever sheets i choose i want to see range(K225:X250) in the same viewing properties "zooming".

    thanks in advance

    Regards
    A.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Response

    Not a full solution but this might help.

    If you set up a separate sheet to hold the value of the address of the current selection (sheet3 in this case), you can use the following two functions in the ThisWorkbook tab on the VBA editor.

    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Range(Sheets("Sheet3").Cells(1, 1)).Select
    End Sub

    Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
    Sheets("Sheet3").Cells(1, 1) = Target.Address
    End Sub

    I couldn't see an event which was triggered by changing the zoombut in case there is one somewhere, you would use similar functions keeping track of the ActiveWindow.Zoom value
    Martin

  3. #3
    Registered User
    Join Date
    12-07-2006
    Posts
    5

    Re: Response

    After almost 5 years, I realized that i didn't thank you for your reply. So thank you.

    this must be a world record of some kind. lol

    A.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1