Freeze panes for titles below row 1

[David77]

Hello everybody,

Is there a way to freeze the title panes below? It seems to be that I can only freeze top and right side panes. I want to freeze these 5 panes here, so once I scroll down below A13-E13 they keep up with me.

 

[jasonb75]

Do you know of any such solutions? or is it a lost cause?

I would say more of the latter, while it might be (theoretically) possible to create some kind of workaround I would be reluctant to call it a solution.

As far as I'm aware, vba has the ability to scroll but not to track scrolling. At best, I would say that you would need to find a way to track scroll movements (API maybe?) then use that to hide and unhide rows as needed to create the appearance of scrolling in the upper section rather than actually scrolling.

You might be lucky to find somebody willing to give it a go, but it is beyond my coding capability.