Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    select all sheets discrep?

    I'd like to be able to view the contents of cell H50 on every WS by clicking on the various sheet tabs. By selecting all sheets and then placing the cellpointer in H50 of the active sheet would seem to be the way to do it. However on the non-active sheets even though the cellpointer is now in H50, I usually have to pagedown to view it. (Selecting all sheets, and then paging down doesn't seem to work).

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: select all sheets discrep?

    Try adding the following into each worksheet:

    Private Sub Worksheet_Activate()
    Cells(50, 8).Activate
    End Sub

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: select all sheets discrep?

    No - simpler way:

    Insert

    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Cells(50, 8).Activate
    End Sub

    Into 'ThisWorkbook'
    Attached Images Attached Images
    • File Type: gif x.gif (6.3 KB, 0 views)

Posting Permissions

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