Question about Freezing Panes

[menor59]

Can i have Row A22 Frozen above and row A173 Frozen below which would leave me with Rows A23:A172 as the scrolling area...The scrolling area would be say 20 rows.

Can this be accomplished?

 

[CodeNinja]

Menor,
Sorry, I thought you could do split and freeze panes at the same time. It seems you cannot.

 

[menor59]

Menor,
Sorry, I thought you could do split and freeze panes at the same time. It seems you cannot.

Not a problem,

Is there another way to get the end result as you see in my attached picture?

 

[menor59]

I selected that but the picture moved when i scrolled...

 

[menor59]

Menor,
Sorry, I thought you could do split and freeze panes at the same time. It seems you cannot.

so i found this code...

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    Dim MyPicture As Object
    Dim MyTop As Double
    Dim MyLeft As Double
    Dim BottomRightCell As Range
    '-----------------------------------------------------------
    '- bottom right cell
    With ActiveWindow.VisibleRange
        r = .Rows.Count
        c = .Columns.Count
        Set BottomRightCell = .Cells(r, c)
    End With
    '------------------------------------------------------------
    '- position picture
    Set MyPicture = ActiveSheet.Pictures(1)
    MyTop = BottomRightCell.Top - MyPicture.Height - 0
    'MyLeft = BottomRightCell.Left - MyPicture.Width - 0
    With MyPicture
        .Top = MyTop
        .Left = MyLeft
    End With
End Sub

help with improving it so the picture stays at the top row as i scroll. Right now when i scroll down i have to click a cell then the picture moves...